Re: Dblink in Oracle10g
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Nov 2008 15:38:52 -0600 (CST)
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# ;
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
