Forum Stats

  • 3,839,768 Users
  • 2,262,532 Discussions


Allow datapump to replace non-table objects

Richard Harrison .
Richard Harrison . Member Posts: 2,065 Gold Trophy
edited Jan 11, 2016 6:13PM in Database Ideas - Ideas


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.



Richard Harrison .User259623 -OracleGeeky NerdmanRobertOrtelvinaykumar2top.gunpankajrangaManish ChaturvedicaadecarvalhoctriebFranck PachotTSharma-OracleLothar FlatzJagadekarabhagatsinghborneselPravin TakpireAish13Brian BakulaRaj JamadagniSven W.François DernoncourtMartinKlierDBAulohmannDear DBA FrankBeGinN.B.2752782berxMortenBratensensoftGbenga AjakayeAndreas HuberBPeaslandDBABlagyHristovaUser_F2Y1CDavidMcWhinnieMartin PreissTHEinternetJustin WarwickBEDEpattonjgNiels Hecker21800user2369446sdstuber
47 votes

Active · Last Updated