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

On Thu, 28 Aug 2008 12:04:55 -0700 (PDT), klabu <klabu76@gmail.com>
wrote:

>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

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

> 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

thanks that was so helpful