OraFAQ Forum: Backup & Recovery » Export User and conserves his userid

Home » RDBMS Server » Backup & Recovery » Export User and conserves his userid

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

Export User and conserves his userid [message #266362]

Mon, 10 September 2007 11:41

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

Report message to a moderator

Re: Export User and conserves his userid [message #266366 is a reply to message #266362]

Mon, 10 September 2007 11:50

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Do you want to switch users on new servers?

Report message to a moderator

Re: Export User and conserves his userid [message #266371 is a reply to message #266366]

Mon, 10 September 2007 12:01

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.

Report message to a moderator

Re: Export User and conserves his userid [message #266378 is a reply to message #266371]

Mon, 10 September 2007 12:22

Michel Cadot
Messages: 68651
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 03:25:19 CDT 2024