Re: "Best" way to copy schema data to another DB
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 14 Apr 2010 09:33:10 -0500 (CDT)
> 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
Interesting. While I don't have the tables individually set for nologging,
the tablespaces are.
It's possible that I've grossly underestimated the amount of redo generated
in a nologging import, but it sure didn't "feel" like that was the case.
Time for more experiments!
But it'll have to wait until after COLLABORATE 10... :)
Thanks for the feedback!
Rich
--
//www.freelists.org/webpage/oracle-l
Other related posts:
