Re: Using database link

Michael L. Hostbaek tried to tell us something, and all I got was:
>
> I tried creating the link with my normal "work" user, but I did not seem
> to have sufficient priviliges to do so. So I logged in a system and did:

I fixed the privilige problem, by grating the right permissions with the system account.

>
> create database link oldora.mydomain.com connect to orauser identified
> by orapass using 'MY_DB';
>

Nevermind. I had messed up the entry in tnsnames.ora. It works now !

/mich

-- 
Regards,
Michael L. Hostbaek
-= So long, and thanks for all the fish.. =-