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 11.2.0.3

unknown-1052419Jan 10 2014 — edited Jan 10 2014

Hi All,

I am importing a dump file but I got lots of error:

CREATE INDEX "BATCHDBA"."ENCARDIDX2" ON "BATCHDBA"."ENCARDTRAN" ("POSTDATE", "CBCODE", "TRANCODE", "TRANAMT")

ORA-39083: Object type INDEX failed to create with error:

ORA-31625: Schema BATCHDBA is needed to import this object, but is unaccessible

ORA-01031: insufficient privileges

Failing sql is:

CREATE INDEX "BATCHDBA"."ENCARDIDX1" ON "BATCHDBA"."ENCARDTRAN" ("POSTDATE", "OBCODE", "OBBRAN", "OBTERM", "CBCODE")

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BATCHDBA"."STABIN_IX" creation failed

ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BATCHDBA"."STABIN_IX2" creation failed

ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BATCHDBA"."KEYH" creation failed

ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BATCHDBA"."MONKEY" creation failed

ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BATCHDBA"."MONKEY2" creation failed

ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BATCHDBA"."BBA_KEY1" creation failed

Please helppppp....

Thanks,

This post has been answered by unknown-1052419 on Jan 10 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 7 2014

Added on Jan 10 2014

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

4 comments

2,754 views