Refresh Schema - Table Data Only

From: klabu <klabu76_at_gmail.com>
Date: Thu, 28 Aug 2008 12:04:55 -0700 (PDT)
Message-ID: <f63729e4-70cf-4bed-b201-2c4371a7696b@m45g2000hsb.googlegroups.com>

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 ?

Should I drop all tables under "scott" ? or truncate them ?
What about existing table constraints/Ref. Integrities...how do I deal with them ?

thanks Received on Thu Aug 28 2008 - 14:04:55 CDT

This message: [ Message body ]
Next message: mh_at_pixar.com: "Re: How should I practise to join Oracle."
Previous message: mh_at_pixar.com: "using "call" for packaged procedure?"
Next in thread: sybrandb_at_hccnet.nl: "Re: Refresh Schema - Table Data Only"
Reply: sybrandb_at_hccnet.nl: "Re: Refresh Schema - Table Data Only"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message