This discussion is archived
4 Replies Latest reply: Oct 1, 2013 7:55 AM by sfrade RSS

impdp exclude some table grants

sfrade Newbie
Currently Being Moderated



I exported a schema containing tables. Each table has grants provided to other schemas.


for example:

the schema CSFDS_BAR grants SELECT, INSERT, UPDATE, DELETE on the table EXAMPLE to the schema CSFDS_FOO

and SELECT on the same table to the schema QUX.

I would like to import the datapump to another schema: ERHPQ_BAR; and remap the grants of the table EXAMPLE of CSFDS_FOO to ERHPQ_FOO but exclude the grant provided to QUX.

I use the following parameters to remap the schemas.



Grants to CSFDS_FOO are correctly remap to ERHPQ_FOO. But I haven't a way to exclude the grants to QUX.

I tried EXCLUDE=OBJECT_GRANT:"GRANTEE in ('QUX')" but failed.


Please advice.




  • Correct Answers - 10 points
  • Helpful Answers - 5 points