Home » RDBMS Server » Server Utilities » User creation while impdp (Oracle 11.2.0.3.0 , Linux 5)
User creation while impdp [message #589599] Tue, 09 July 2013 02:00 Go to next message
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.
Re: User creation while impdp [message #589600 is a reply to message #589599] Tue, 09 July 2013 02:09 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes but the roles themselves are not created (unless you specified them on the export).

Regards
Michel
Re: User creation while impdp [message #589632 is a reply to message #589600] Tue, 09 July 2013 04:51 Go to previous messageGo to next message
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
Re: User creation while impdp [message #589636 is a reply to message #589632] Tue, 09 July 2013 05:29 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: User creation while impdp [message #589687 is a reply to message #589636] Wed, 10 July 2013 01:11 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Sure Michel
Re: User creation while impdp [message #592370 is a reply to message #589599] Wed, 07 August 2013 04:28 Go to previous messageGo to next message
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


Re: User creation while impdp [message #592378 is a reply to message #592370] Wed, 07 August 2013 05:41 Go to previous message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Import only tables of a schema
Next Topic: impdp in linux ..help in this
Goto Forum:
  


Current Time: Sat Aug 30 13:51:23 CDT 2014

Total time taken to generate the page: 0.06561 seconds