Re: impdp Issue

Scott,

     Very nice.  In this case impdp should work, but I'm no guru at the command line implementation.  Give me the day while I extract how I use to do this with in PL/SQL on a routine basis.

On 9/11/2024 13:09, Scott Canaan wrote:
>
> That is correct.  The database link is in the database and it works. 
> I can pull data from the remote database using the database link in
> SQL*Plus:
>
> SQL> select name, created from v$database_at_advcprod;
>
> NAME CREATED
>
> --------- ---------
>
> ADVCPROD 23-DEC-16
>
> SQL> select name, created from v$database;
>
> NAME CREATED
>
> --------- ---------
>
> ADVCDEVL 01-AUG-23
>
> *Scott Canaan ‘88**
> */Sr Database Administrator
> /Information & Technology Services
> Finance & Administration **
>
> *Rochester Institute of Technology
> *o: (585) 475-7886 | f: (585) 475-7520**
>
> _srcdco_at_rit.edu_| c: (585) 339-8659
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it
> is addressed and may contain confidential and/or privileged material.
> Any review, retransmission, dissemination or other use of, or taking
> of any action in reliance upon this information by persons or entities
> other than the intended recipient is prohibited. If you received this
> in error, please contact the sender and destroy any copies of this
> information.
>
> *From:*oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>
> *On Behalf Of *richard goulet
> *Sent:* Wednesday, September 11, 2024 12:51 PM
> *To:* Oracle L <oracle-l_at_freelists.org>
> *Subject:* impdp Issue
>
> It's been a bit, but as I remember to use a db link with IMPDP or
> EXPDP you have to have it defined within the database your logging
> into.  By that I mean where your running the datapump process from as in
>
> CREATE DATABASE LINK 'advcprod.world' USING 'advcprod.world';
>
> So that the following will work:
>
> select * from global_name_at_advcprod.world';
>
> This is because your spawning the data pump process within the local
> database to the remote database.
>

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