impdp Issue

From: richard goulet <"richard>
Date: Wed, 11 Sep 2024 12:50:38 -0400
Message-ID: <d69aa01d-b8b9-43dd-bdc0-a0a5ef602f9e_at_comcast.net>

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

Received on Wed Sep 11 2024 - 18:50:38 CEST