OraFAQ Forum: Server Utilities » User creation while impdp

Home » RDBMS Server » Server Utilities » User creation while impdp (Oracle 11.2.0.3.0 , Linux 5)

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

User creation while impdp [message #589599]

Tue, 09 July 2013 02:00

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Hi,

I have a question to clarify regarding user creation during export and import.

Will user get created along with roles,privileges by default when using impdp command ?

Regards,
Suhas.

Report message to a moderator

Re: User creation while impdp [message #589600 is a reply to message #589599]

Tue, 09 July 2013 02:09

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes but the roles themselves are not created (unless you specified them on the export).

Regards
Michel

Report message to a moderator

Re: User creation while impdp [message #589632 is a reply to message #589600]

Tue, 09 July 2013 04:51

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Michel,

Thank you.

Quote:

the roles themselves are not created (unless you specified them on the export).

Could you tell me what is parameter to specify on the export command ?

Regards,
Suhas

Report message to a moderator

Re: User creation while impdp [message #589636 is a reply to message #589632]

Tue, 09 July 2013 05:29

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I think you have to do a full backup specifying what you actually want with INCLUDE options like 'INCLUDE=ROLE' for all the roles or 'INCLUDE=DEFAULT_ROLE' for the default roles granted to users.
You have to make some test.

Regards
Michel

Report message to a moderator

Re: User creation while impdp [message #589687 is a reply to message #589636]

Wed, 10 July 2013 01:11

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Sure Michel

Report message to a moderator

Re: User creation while impdp [message #592370 is a reply to message #589599]

Wed, 07 August 2013 04:28

8939513598$
Messages: 103
Registered: July 2013
Location: chennai

Senior Member

first you'll have to check with to add EXCLUDE, INCLUDE parameters along with impdp, example:INCLUDE=TABLE_DATA

Report message to a moderator

Re: User creation while impdp [message #592378 is a reply to message #592370]

Wed, 07 August 2013 05:41

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I doubt that INCLUDE=TABLE_DATA will ever lead to "Will user get created along with roles,privileges by default when using impdp command ?"
One more useless posts from you.

Regards
Michel

Report message to a moderator

Previous Topic:	Import only tables of a schema
Next Topic:	impdp in linux ..help in this

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 05 03:20:57 CST 2026