 | |
Refresh Schema - Table Data Only
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Refresh Schema - Table Data Only -
08-28-2008
, 02:04 PM
#2
| |||
| |||
|
|
10gR2 I want to refresh a shema - data only If I'm to use expdp to export "scott" from Production and use impdp to import to "scott" on Test.... What is the best approach on the import ? 1) Should I drop all tables under "scott" ? or truncate them ? 2) What about existing table constraints/Ref. Integrities...how do I deal with them ? thanks |
various commandline options dealing with exactly this.
As I don't know them by heart, and would need to reread the
documentation, you'd better do this.
--
Sybrand Bakker
Senior Oracle DBA
#3
| |||
| |||
|
|
10gR2 I want to refresh a shema - data only If I'm to use expdp to export "scott" from Production and use impdp to import to "scott" on Test.... What is the best approach on the import ? 1) Should I drop all tables under "scott" ? or truncate them ? 2) What about existing table constraints/Ref. Integrities...how do I deal with them ? thanks |
various commandline options dealing with exactly this.
As I don't know them by heart, and would need to reread the
documentation, you'd better do this.
--
Sybrand Bakker
Senior Oracle DBA
#4
| |||
| |||
|
|
10gR2 I want to refresh a shema - data only If I'm to use expdp to export "scott" from Production and use impdp to import to "scott" on Test.... What is the best approach on the import ? 1) Should I drop all tables under "scott" ? or truncate them ? 2) What about existing table constraints/Ref. Integrities...how do I deal with them ? thanks |
various commandline options dealing with exactly this.
As I don't know them by heart, and would need to reread the
documentation, you'd better do this.
--
Sybrand Bakker
Senior Oracle DBA
#5
| |||
| |||
|
|
10gR2 I want to refresh a shema - data only If I'm to use expdp to export "scott" from Production and use impdp to import to "scott" on Test.... What is the best approach on the import ? 1) Should I drop all tables under "scott" ? or truncate them ? 2) What about existing table constraints/Ref. Integrities...how do I deal with them ? thanks |
various commandline options dealing with exactly this.
As I don't know them by heart, and would need to reread the
documentation, you'd better do this.
--
Sybrand Bakker
Senior Oracle DBA
#6
| |||
| |||
|
|
1) the documentation for impdp in the Oracle Utilities Manual outlines various commandline options dealing with exactly this. As I don't know them by heart, and would need to reread the documentation, you'd better do this. -- Sybrand Bakker Senior Oracle DBA |
#7
| |||
| |||
|
|
1) the documentation for impdp in the Oracle Utilities Manual outlines various commandline options dealing with exactly this. As I don't know them by heart, and would need to reread the documentation, you'd better do this. -- Sybrand Bakker Senior Oracle DBA |
#8
| |||
| |||
|
|
1) the documentation for impdp in the Oracle Utilities Manual outlines various commandline options dealing with exactly this. As I don't know them by heart, and would need to reread the documentation, you'd better do this. -- Sybrand Bakker Senior Oracle DBA |
#9
| |||
| |||
|
|
1) the documentation for impdp in the Oracle Utilities Manual outlines various commandline options dealing with exactly this. As I don't know them by heart, and would need to reread the documentation, you'd better do this. -- Sybrand Bakker Senior Oracle DBA |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.