Re: "Best" way to copy schema data to another DB

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • To: rjoralist@xxxxxxxxxxxxxxxxxxxxx
  • Date: Wed, 14 Apr 2010 09:34:33 +0300

According to: http://yong321.freeshell.org/oranotes/DataPump.txt by Yong Huang. 


If the table was in nologging then impdp do not generate redo log.

so:
1) Impdp structure only.
2) Alter all tables to nologging.
3) Impdp with ignore=y with network_link.
4) Alter all tables back to logging.

Use at your own risk. : I did not check that what he writes is correct.

Adar Yechiel
Rechovot, Israel



Rich Jesse wrote:

I've alsotried using the NETWORK_LINK option of impdp, but it refuses to use 
APPEND.


--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2010