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!

table_exists_action parameter in IMPDP

Santosh PradhanJul 23 2012 — edited Jul 23 2012

Hi all,

I have expdp export dmp file and i want to refresh the schema in UAT and i dont want to drop the UAT schema.

Suppose i m using "table_exists_action=truncate" parameter in impdp so what will happen to existing procedures, packages, triggers means (all dependant objects) of both UAT and PROD?

And suppose i have created one procedure and one trigger in UAT db which is not present in Production DB and i wnat to import that dmp file which contain new procedure and trigger to Prod DB using with""table_exists_action=truncate" parameter so that procedure and trigger will be imported to PROD db or not?

Please suggest......

Regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 20 2012

Added on Jul 23 2012

#database-key-features, #export-import-sql-loader-external-tables

7 comments

4,414 views