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

Other related posts: