Home » RDBMS Server » Server Administration » user transfer (Oracle 11.2.0.1, windows 2008 R2)
user transfer [message #544785] Thu, 23 February 2012 15:37 Go to next message
patdev
Messages: 55
Registered: August 2008
Member
Hi All,

i want to transfer all users from server A to server B how can i do that along with their rights and password?

thanks
Re: user transfer [message #544787 is a reply to message #544785] Thu, 23 February 2012 15:51 Go to previous messageGo to next message
joy_division
Messages: 4544
Registered: February 2005
Location: East Coast USA
Senior Member
One way would be export and import (exp and imp).
Re: user transfer [message #544812 is a reply to message #544787] Thu, 23 February 2012 23:14 Go to previous message
Michel Cadot
Messages: 59731
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
... or better in your version, data pump, expdp and impdp.

Regards
Michel
Previous Topic: oracle uid
Next Topic: Unable to extract ddl of tablespace
Goto Forum:
  


Current Time: Thu Nov 20 20:52:24 CST 2014

Total time taken to generate the page: 0.16250 seconds