RE: Dblink in Oracle10g
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <rjoralist@xxxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Nov 2008 08:41:52 -0500
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@xxxxxxxxxxx
x72546
904 727-2546
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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!!!)
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
