Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB Links in different schemas

936749Sep 14 2012 — edited Nov 8 2012

Hi,
I'd like to change DB links in different schemas with SYS user.
I've tried to create a script to change all DB links (database it should connect to and password)

ALTER DATABASE LINK "database_link"
CONNECT TO database IDENTIFIED BY password;

ORA-02024: database link not found

Is there no way to do this as SYS? Do I need to logon to everey schema in the database and alter the DB link?
Regards
933746

Edited by: 933746 on Sep 14, 2012 12:09 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 6 2012

Added on Sep 14 2012

#11g, #database, #general-database-discussions, #installation

6 comments

170 views