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

Slightly OT but another major difference between exp and expdp: you need database server access for expdp.
With exp developers can run exp/imp to refresh tables via their desktops; they lose this ability with data pump unless they have a login to the database server - which is not allowed in many shops. I think that similar to bcp for sybase, exp is one of Oracle's crown jewels and DP is really quite a different utility. I think both are needed.

Rgds
Mark

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yechiel Adar Sent: 14 April 2010 14:35
To: rjoralist_at_society.servebeer.com
Cc: oracle-l_at_freelists.org
Subject: Re: "Best" way to copy schema data to another DB

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



=============================================================================== 
Please access the attached hyperlink for an important electronic communications disclaimer: 
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html 
=============================================================================== 

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