Re: impdp Issue

The only thing I can think of at present is that you're allowed to use the database link when you connect to SQL*Plus but impdp does something that requires the link to be defined differently (e.g. you've got a private database link, but your use of impdp requires a public database link).

Regards
Jonathan Lewis

On Tue, 10 Sept 2024 at 13:26, Scott Canaan <dmarc-noreply_at_freelists.org> wrote:

> I’m trying to import from one database to another via the network. I’ve
> done this many, many times with no issues, until now. I create the
> database link, put the entry in the tnsnames.ora file, and verified that
> all is good. The tnsping returns correctly. I can query the remote
> database from SQL*Plus with no issue, but when I try to run the impdp, I
> get:
>
>
>
> ORA-39001: invalid argument value
>
> ORA-39200: Link name "advcprod" is invalid.
>
> ORA-12154: TNS:could not resolve the connect identifier specified
>
>
>
> The source database is Oracle 12.1 on Red Hat 7, the destination database
> is Oracle 19 on Red Hat 8. I’ve tried setting the SID and SERVICE_NAME in
> the tnsnames.ora file and it doesn’t matter, I get the same error either
> way.
>
>
>
> *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 <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.
>
>
>

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