Home » RDBMS Server » Server Administration » 9i Database Links
9i Database Links [message #195404] Thu, 28 September 2006 07:49 Go to next message
dreckers
Messages: 3
Registered: September 2006
Location: West Sussex
Junior Member

Hi there, just a quick one I hope...

I am merging two databases into one which has gone well apart from the database links that I have found. The question is.....

How do I recreate the 'sys' owned database links as the users that are being used for the links need passwords that I do not know?

Thanks for any help?
Re: 9i Database Links [message #195432 is a reply to message #195404] Thu, 28 September 2006 10:20 Go to previous message
ramakris
Messages: 21
Registered: July 2006
Location: Delhi
Junior Member
Login as sqlplus / as sysdba in the box

and,

SQL> alter user sys identified by <your new pwd>;

That's it.

Thanks!
Previous Topic: Project trial period of 3 months
Next Topic: ORA-12514: TNS: Listener does not currently know of service requested
Goto Forum:
  


Current Time: Sun Dec 08 05:29:09 CST 2024