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<mailto: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
