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

Report message to a moderator

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: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 04 07:15:20 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.