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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Yechiel Adar Sent: 14 April 2010 14:35 To: rjoralist@xxxxxxxxxxxxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx 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. > > -- //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 =============================================================================== -- //www.freelists.org/webpage/oracle-l