Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Advice for dblinks between two prod DBs.
My knee jerk, based on what I've seen so far, would be to script up
something like:
Any other way *supported* way of doing this?
Rich
-----Original Message-----
From: Guerra, Abraham J [mailto:AGUERRA_at_amfam.com]
Sent: Wednesday, November 22, 2006 8:33 AM
To: Mercadante, Thomas F (LABOR); Jesse, Rich; oracle-l_at_freelists.org
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_at_labor.state.ny.us]
Sent: Wednesday, November 22, 2006 8:25 AM
To: Guerra, Abraham J; Rich.Jesse_at_qg.com; oracle-l_at_freelists.org
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 22 2006 - 08:40:47 CST