Home » RDBMS Server » Backup & Recovery » Export User and conserves his userid
icon5.gif  Export User and conserves his userid [message #266362] Mon, 10 September 2007 11:41 Go to next message
tony_pe
Messages: 17
Registered: August 2007
Junior Member
Hi,
I'm making Export the one instance a others.

But, i want to export my users and that his conserving "usersid"

I have used imp/exp full and owner (for example: sys), and nothing?


How to export my users to a new server and conserves his userid?

anything help.

Thanks
Re: Export User and conserves his userid [message #266366 is a reply to message #266362] Mon, 10 September 2007 11:50 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Do you want to switch users on new servers?
Re: Export User and conserves his userid [message #266371 is a reply to message #266366] Mon, 10 September 2007 12:01 Go to previous messageGo to next message
tony_pe
Messages: 17
Registered: August 2007
Junior Member
Not on the contrary, I want that the users are such, that is to say, conserve all its attributes (one of them is the USERID);
since making export and soon import these change in the new server.
Re: Export User and conserves his userid [message #266378 is a reply to message #266371] Mon, 10 September 2007 12:22 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't choose the userid and have no control on it.
If you want the same in both database, you have to create the users in the same order.

Regards
Michel
Previous Topic: How to recover only one table with no flashback option in 9i
Next Topic: ORA-01033 ORACLE initialization or shutdown in progress
Goto Forum:
  


Current Time: Sat Dec 10 05:02:48 CST 2016

Total time taken to generate the page: 0.15368 seconds