Re: Refresh Schema - Table Data Only
Date: Thu, 28 Aug 2008 21:24:58 +0200
On Thu, 28 Aug 2008 12:04:55 -0700 (PDT), klabu <klabu76_at_gmail.com> wrote:
>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 ?
- 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 DBAReceived on Thu Aug 28 2008 - 14:24:58 CDT