Skip to Main Content

Database Software

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!

Allow datapump to replace non-table objects

Richard Harrison .Nov 14 2014 — edited Jan 11 2016

Hi,

An often asked question on the forum (asked again today) is to let datapump replace objects other than tables.

Currently TABLE_EXISTS_ACTION=REPLACE allows tables to be dropped and recreated but all other objects (well other than indexes indirectly by tables being dropped) such as functions/procedures/packages all fail to create as the objects already exist. It would be great if there was another setting to force the replacement of other objects - this should be easy to do as all that needs to change is the adding of 'or replace' to the create command.

Cheers,

Rich

Comments

Post Details

Added on Nov 14 2014
7 comments
2,159 views