Re: Data Pump over NETWORK_LINK

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Mon, 20 Apr 2009 19:05:31 -0300
Message-ID: <172762180904201505q334e7fcua45b685254c064cf_at_mail.gmail.com>

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_at_dpsg.com> 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_at_dpsg.com 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.
>
>

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

Received on Mon Apr 20 2009 - 17:05:31 CDT