Home » RDBMS Server » Server Utilities » User Creation Definition in User Mode Export (Oracle 9i,10g on Linux)
User Creation Definition in User Mode Export [message #449663] Wed, 31 March 2010 06:13 Go to next message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
Hi,

I would like to know if 'user creation definition' is exported in user mode export if export is done with DBA role

If it is Not, does it mean we always need to precreate the user before we import the dump created using 'user mode export'?

Thanks and Regards,
Chetana
Re: User Creation Definition in User Mode Export [message #449670 is a reply to message #449663] Wed, 31 March 2010 06:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Only full export contains account creation statements.

Quote:
If it is Not, does it mean we always need to precreate the user before we import the dump created using 'user mode export'?

Yes.

Regards
Michel
Re: User Creation Definition in User Mode Export [message #449672 is a reply to message #449663] Wed, 31 March 2010 06:41 Go to previous message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
Superb!

Thank you very much. It is clear to me now.

Regards,
Chetana
Previous Topic: .DMP Restoration
Next Topic: Import Oracle 10g dump into 9i database
Goto Forum:
  


Current Time: Fri Mar 29 03:17:13 CDT 2024