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!

Import Just Procedures and Packages

Michael8773Dec 5 2016 — edited Dec 6 2016

Hello,

I need to just refresh the Procedures, Functions, Triggers and Packages from a production schema to test.

I tried variations of this in a schema import:

CONTENT=METADATA_ONLY
DIRECTORY=datapump
DUMPFILE=x15_schema_prod.dmp
JOB_NAME=impSchema
LOGFILE=impSchema.log
SCHEMAS=x15
TABLE_EXISTS_ACTION=replace

It will not overwrite the existing meta type objects as I get messages like this:

ORA-31684: Object type PROCEDURE:"X15"."MYPROC" already exists

What can you recommend?

Thanks,

Michael

This post has been answered by Gbenga Ajakaye on Dec 5 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 2 2017

Added on Dec 5 2016

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

5 comments

1,883 views