Refresh Schema - Table Data Only

From: klabu <>
Date: Thu, 28 Aug 2008 12:04:55 -0700 (PDT)
Message-ID: <>

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 ?

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

Original text of this message