Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datapump : import users grant

451915Jul 11 2007 — edited Jul 11 2007
Hi,

I did the export below in one of my database server :
expdp .... dumpfile=test.dmp full=y include=profile,role,user,grant

Then i try to import all this in my target database with the following command :
impdp user/user directory=dpump_dir dumpfile=test.dmp parfile=exclude.par
The exclude.par only contains user i don't want to import.

Everything seems to work fine.

But when i look to the grant of my user, grants are missing.
For example, none of my imported user have the role "connect".

Is this normal behaviour, is there special command to have role granted to users ?

Thanks for answer.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 8 2007
Added on Jul 11 2007
7 comments
2,685 views