RE: Dblink in Oracle10g

The script would be better off changing the password back to its original immediately after connecting to the local user account. There is no need to do all the work first if as the description warns about changing a password even for a few seconds. Well if you change it back immediately it wouldn't be your password for longer than it takes to connect.

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Jesse Sent: Tuesday, November 18, 2008 12:46 PM To: oracle-l
Subject: Re: Dblink in Oracle10g

Hey Bradd,

While not exactly a workaround, here's one scripting method that might help:

http://asktoad.com/DWiki/doku.php/howto_create_dblinks_database_links_in _another_schema

(or http://tinyurl.com/ToadDBLinks for the long URL impaired email)

I used Toad to do this, but I suppose one could use an inferior product... ;)

Rich

> I should have stated it was my opinion that it seems cleaner to me. I
> already have DataPump set up on my databases. I believe it would also
take
> care of any 'become user' issues when doing the import rather than
having to
> code 'connect' statements for the private database links. (If there is
a
> better way to do this part, I'd love to see how that is done!!!)

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


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