Re: import/export

On 16 Okt., 15:17, sybrandb <sybra..._at_gmail.com> 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