Re: Refresh Schema - Table Data Only

From: <>
Date: Thu, 28 Aug 2008 21:24:58 +0200
Message-ID: <>

On Thu, 28 Aug 2008 12:04:55 -0700 (PDT), klabu <> 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. do I
>deal with them ?

  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
Received on Thu Aug 28 2008 - 14:24:58 CDT

Original text of this message