Home » RDBMS Server » Server Administration » merging Databases (oracle 10g, OEL5)
merging Databases [message #352030] Sun, 05 October 2008 07:02 Go to next message
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
Re: merging Databases [message #352039 is a reply to message #352030] Sun, 05 October 2008 09:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: merging Databases [message #352040 is a reply to message #352039] Sun, 05 October 2008 09:05 Go to previous message
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:
  


Current Time: Sat Dec 03 15:51:05 CST 2016

Total time taken to generate the page: 0.11702 seconds