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!

Impdp specific schema from dump which has been created using full=y

856103Aug 16 2012 — edited Aug 16 2012

Hi,

I have received a dump (expdp) which has been created using the parameter FULL=Y. I just want to import (impdp) only one schema into my database. I have used remap_schema and exclude=grants. The schema i want to import is carried out successfully, but in my import log i keep getting the messages such as :

ORA-31684: Object type TABLESPACE:"TS_BCST1" already exists

ORA-31684: Object type USER:"OUTLN" already exists

ORA-31684: Object type SEQUENCE:"SYSTEM"."MVIEW$_ADVSEQ_GENERIC" already exists

How can i use impdp only to import objects under my specific schema and not have impdp attempt to create system/sys users and its objects, create tablespaces, etc etc.

Kindly assist.

Regards,
Karan

This post has been answered by Helios-GunesEROL on Aug 16 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 13 2012

Added on Aug 16 2012

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

4 comments

25,060 views