RE: database link re-creation

From: Henry Poras <Henry.Poras_at_ctp.com>
Date: Mon, 30 Oct 2000 17:29:55 -0500
Message-Id: <10665.120620@fatcity.com>

How about having a production and a test tnsnames.ora They will have the same alias names, just point to different SIDs. The only other thing to do would be to change appropriate passwords.

Henry

-----Original Message-----
From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org] Sent: Monday, October 30, 2000 1:42 PM
To: oracle-l_at_fatcity.com; ORACLE-L_at_IC.SUNYSB.EDU; ORACLE-DB-L_at_OPENITX.COM; oracledba_at_QuickDoc.co.uk; iouga-vms-l_at_resource.to
Subject: database link re-creation

Anybody have a good way to recreate database links after copying a production database to test.

For examp, in prod_1 link_a points to database prod_2.

After copying prod_1 to test_1, I would want link_a to to point to test_2. Other than do the following is there a better way:

1. connect as the link's owner (since can not create a link in another schema) by
   • storing current password
   • setting password to known value
   • connecting
2. drop the old link and create the new one.
3. put back the old password.

Since development, I tried updateing sys.link$ directly to change the "host" name, but SQL still accessed original database!!

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

---

Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com Received on Mon Oct 30 2000 - 16:29:55 CST