RE: Advice for dblinks between two prod DBs.
- From: "Jesse, Rich" <Rich.Jesse@xxxxxx>
- To: "Guerra, Abraham J" <AGUERRA@xxxxxxxxx>, "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 22 Nov 2006 08:40:47 -0600
My knee jerk, based on what I've seen so far, would be to script up
something like:
1) Grab the dblinks from DBA_DB_LINKS
2) For each owner:
2a) Save their password from USER$
2b) Change the password
2c) Login as that user
2d) Drop/recreate the dblink.
2e) Reset the password, based on the saved value.
3) Repeat
Any other way *supported* way of doing this?
Rich
-----Original Message-----
From: Guerra, Abraham J [mailto:AGUERRA@xxxxxxxxx]
Sent: Wednesday, November 22, 2006 8:33 AM
To: Mercadante, Thomas F (LABOR); Jesse, Rich; oracle-l@xxxxxxxxxxxxx
Subject: RE: Advice for dblinks between two prod DBs.
How would you delete dblinks that came over when you clone a database
with a new name? I would be interested to know...
Abraham
-----Original Message-----
From: Mercadante, Thomas F (LABOR)
[mailto:Thomas.Mercadante@xxxxxxxxxxxxxxxxx]
Sent: Wednesday, November 22, 2006 8:25 AM
To: Guerra, Abraham J; Rich.Jesse@xxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Advice for dblinks between two prod DBs.
Only a fool would take this advice.
Updating internal tables directly with the advice of Oracle support is
asking for a complete database restore.
I would strongly suggest you do not do this.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
