RE: database link re-creation

I've found that the answer you got the first time was quite good : in the TNSNAMES.ORA of your test box, make the entry link_a point to test_2 and voila !

BTW, I'm also interested in your link$ tests : I'll look at this ; please let me know if you find something.

> ----------
> From: Jeffrey Beckstrom[SMTP:JBECKSTROM_at_gcrta.org]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Friday, November 03, 2000 13:40
> To: Multiple recipients of list ORACLE-L
> Subject: database link re-creation
>
> Reposting - somebody has to be use database links. How do you handle
> their recreation whem moving the datbase from production to development.
>
> 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
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeffrey Beckstrom
> INET: JBECKSTROM_at_gcrta.org
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Nov 03 2000 - 08:05:47 CST