Re: Refresh Schema - Table Data Only

From: <sybrandb_at_hccnet.nl>
Date: Thu, 28 Aug 2008 21:24:58 +0200
Message-ID: <4pudb45hbp29es6ibpamkl1sq8ghd417pc@4ax.com>


On Thu, 28 Aug 2008 12:04:55 -0700 (PDT), klabu <klabu76_at_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
Received on Thu Aug 28 2008 - 14:24:58 CDT

Original text of this message