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: 73
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

Report message to a moderator

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: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
One way would be export and import (exp and imp).

Report message to a moderator

Re: user transfer [message #544812 is a reply to message #544787] Thu, 23 February 2012 23:14 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
... or better in your version, data pump, expdp and impdp.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 08:15:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.