Hello,
running several Oracle Databases with version 11.2.0.2 I came across the following problem in our setup:
I'm asked to copy database 1 from environment A to environment B and adjust existing database links inside the new environment.
A little more "detailed":
- In environment A, an export of database 1 is performed.
- In environment B, this export is imported as database 1i <= name change (as is done for other databases, too).
- There exist database links in database 1 in environment A that point to database 2 in environment A.
- In environment B, these links shall be changed inside database 1i to point to database 2i in environment B (and NOT to database 2 in environment A).
Now the questions:
1. Is it possible to change a database link as DBA, which is owned by anyone else?
2. Is it possible to ONLY change the connect string (or (remote) host name) of a database link? (This means leaving the credentials etc. as is, which have been inserted at the creation time of the database link...)
Thanks in advance for any help.
Best regards,
Patrick