OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » merging Databases (oracle 10g, OEL5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

merging Databases [message #352030]

Sun, 05 October 2008 07:02

ziadaher
Messages: 70
Registered: October 2007
Location: lebanon

Member

dear gentlemen;

i am merging two databases in one, i am done with everything, but i was thinking, instead of creating users from scratch, and ask them to change their default password if there was a way to get the old passwords of the users and put it in the new server(without affecting the database)
i know for a fact that the dba_users table cant be modified. i was wondering if i copy and merge the two old password files, will it work smoothly ?

any suggestions ?

thank you

Report message to a moderator

Re: merging Databases [message #352039 is a reply to message #352030]

Sun, 05 October 2008 09:01

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Take the password hash value from dba_users.password and then use the undocumented statement:
alter user ... identifified by values '<the hashed value you found>';

Regards
Michel

Report message to a moderator

Re: merging Databases [message #352040 is a reply to message #352039]

Sun, 05 October 2008 09:05

ziadaher
Messages: 70
Registered: October 2007
Location: lebanon

Member

thank u very much

[Updated on: Sun, 05 October 2008 09:07]

Report message to a moderator

Previous Topic:	Dropped child partition retains fk constraint with parent partition after row movement
Next Topic:	ORA-30036: unable to extend segment by 1024 in undo tablespace 'UNDOTBS1'

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 17:41:21 CST 2024