Re: Dblink in Oracle10g

Most of the discussion on this thread has been that this approach won't work. Instead of creating a database link called "MYLINK" in schema "MYUSER", it will create one called "MYUSER.MYLINK" in the current schema. Try it.

Rich

> perfect... thanks a lot ..i used method 2 and created a dynamic script as
> below to create the dblink
>
> SELECT
> 'create '||DECODE(U.NAME,'PUBLIC','public ')||'database link '||CHR(10)
> ||DECODE(U.NAME,'PUBLIC',Null, U.NAME||'.')|| L.NAME||chr(10)
> ||'connect to ' || L.USERID || ' identified by values'''
> ||L.PASSWORDX||''' using ''' || L.host || ''''
> ||chr(10)||';' TEXT
> FROM sys.link$ L,
> sys.user$ U
> WHERE L.OWNER# = U.USER# ;
>

--
http://www.freelists.org/webpage/oracle-l