That's the only way I know how.
Drop the link, because it is pointing to the incorrect
db.
Recreate the database with the new pointer.
G!
--- Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote: >
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 - 13:15:06 CST
