Friday, 18 December 2015

Impdp ORA-39111 dependent object type object_grant skipped

During a Data Pump import job, a dependent object is being skipped because its base object already existed. Use import parameter in parfile
    
        table_exists_action=replace

So it replace only the tables not the other  independent objects. 

Note: Table exists action parameter work without any issue only when there is no foreign key constraints in the import tables.

Solution:
To run a clean import drop all the objects of the schema and start import again.To drop all the objects at a time and for  complete import  steps  please refer the links.

http://swadhinur.blogspot.com/2015/12/schema-refresh-step-by-step.html

No comments:

Post a Comment