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?

Report message to a moderator

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!

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 06:32:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.