Re: import/export

On Oct 16, 11:46 am, joe <fischauto..._at_yahoo.de> wrote:
> 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?

Define what you mean by 'user have all privileges', because Oracle is telling you otherwise.

David Fitzjarrell Received on Thu Oct 16 2008 - 12:13:05 CDT