Re: import/export

From: joe <>
Date: Thu, 16 Oct 2008 09:46:32 -0700 (PDT)
Message-ID: <>

On 16 Okt., 15:17, sybrandb <> wrote:
> What you need to do is very simple:
> 1 create a database link in the *target* database to the *source*
> database
> 2 run *impdp*, using the NETWORK_LINK parameter, specifying the
> database link you created in step 1
> You don't need to export!!!

Step 1 seems to work, i can do a:

select * from xyz_at_dblinkname

But when i run impdp:
./impdp username/password DIRECTORY=dmpdir NETWORK_LINK=dblinkname

i get the following error message, even when the user have all privileges
on both databases:

UDI-00008: operation generated ORACLE error 12546 ORA-12546: TNS:permission denied

any hint? Received on Thu Oct 16 2008 - 11:46:32 CDT

Original text of this message