have you tried it? (perhaps testing in prod/dev is not a good idea, do you have a lab?) Alan Bort Oracle Certified Professional On Mon, Apr 20, 2009 at 5:05 PM, Xu, Roger <Roger.Xu@xxxxxxxx> wrote: > Here is how I currently copy a schema from production to dev in 10gR2 – > > > > 1) expdp system/password1 schemas=HR directory=pump_dir1 dumpfile=hr.dmp > > 2) FTP the dump file (hr.dmp) to the dev box > > 3) drop user TESTHR in the dev box > > 4) impdp system/password2 schemas=TESTHR directory=pump_dir2 > dumpfile=hr.dmp remap_schema=HR:TESTHR > > 5) reset password for TESTHR (alter user TESTHR identified by ??????) > > > > Now my question is: how do I do this over the NETWORK_LINK? What kind of DB > link I need? > > > > Would the command looks like this? > > > > impdp system/password2 schemas=TESTHR directory=pump_dir2 > network_link=mydblink remap_schema=HR:TESTHR > > > > > > Thanks > > > > Roger > > > > *Click here <http://www.drpeppersnapplegroup.com/about/corporate>* to > learn more about Dr Pepper Snapple Group’s commitment to corporate* * > social* *responsibility. > > Please be conscious of the environment and print this email only if > absolutely necessary. > > This e-mail (including any attachments) is confidential and may contain > privileged information of Dr Pepper Snapple Group, Inc. and/or its > subsidiaries ("Dr Pepper Snapple Group"). If you are not the intended > recipient or receive it in error, you may not use, distribute, disclose or > copy any of the information contained within it and it may be unlawful to do > so. If you are not the intended recipient, please notify us immediately by > returning this e-mail to us at mailerror@xxxxxxxx and destroy all > copies. Any views expressed by individuals within this e-mail do not > necessarily reflect the views of Dr Pepper Snapple Group. This e-mail does > not constitute a binding offer, acceptance, amendment, waiver or other > agreement, unless the intent that an e-mail will constitute such is clearly > stated in the body of the email. Recipients are advised to subject this > e-mail and attachments to their own virus checking, in keeping with good > computing practice. Please note that e-mail received by Dr Pepper Snapple > Group may be monitored in accordance with applicable law. > >