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.

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


Other related posts: