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: by Yong Huang.

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

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 


Other related posts: