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!

Replace all 'already exist' object when doing full import (impdp)

User_AAD34Aug 18 2015 — edited Aug 19 2015

Hi,

I'm trying to do a full import from one database to another database.

i've already exported (expdp) all the object from a database without any problem, but when i tried to import (impdp) them to another database, some error were shown, like ' ORA-31684: Object type ... already exists'.

My question is how to replace already exist objects (old to new) , so that it won't show any error?

if i use TABLE_EXISTS_ACTION=REPLACE, isn't it replaced only the tables and not other objects? I've already tried and there were still some error.

Any hints will be highly appreciated. Thanks in advance.

Regards,

Jerry Antonius

This post has been answered by rchem on Aug 18 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 15 2015

Added on Aug 18 2015

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

2 comments

10,041 views