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
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