RE: Advice for dblinks between two prod DBs.

From: <oracle-l-bounce_at_freelists.org>
Date: Wed, 22 Nov 2006 08:24:09 -0600
Message-ID: <FB5D3CCFCECC2948B5DCF4CABDBE6697A525D7@QTEX1.qg.com>

Hmmmm...since the clone would be a test DB anyway, I just might do that. Thanks, Abraham!

Rich

-----Original Message-----

From: Guerra, Abraham J [mailto:AGUERRA_at_amfam.com] Sent: Wednesday, November 22, 2006 8:22 AM To: Jesse, Rich; oracle-l_at_freelists.org
Subject: RE: Advice for dblinks between two prod DBs.

Hello Rich,

Try running this before you drop and recreate your database link:

update sys.props$
set value$ = 'DBNAME_YOU_CLONE_FROM'
where name = 'GLOBAL_DB_NAME';

commit;

drop database link....;

update sys.props$
set value$ = 'NEW_DBNAME'
where name = 'GLOBAL_DB_NAME';

commit;

create database link ....;

Hope it helps,

Abraham
--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 22 2006 - 08:24:09 CST