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!

11g DataPump. ORA-14102 during expdp/impdp process

756295Feb 25 2010 — edited Feb 23 2011

Hello!
I have a problem with copy data from one schema to another in oracle 11g.

I use oracle 11.2.0.1.0 and try to copy data with expdp/impdp utility.

I make dump file by follow command:

expdp user/*** SCHEMAS=proxima_release DUMPFILE=data.dmp LOGFILE=exp.log

Export ends with no warning.

Then I try to import data with follow command:

impdp user/*** SCHEMAS=proxima_release DUMPFILE=data.dmp REMAP_SCHEMA=proxima_release:proxima_demo LOGFILE=imp.log

During import oracle does not create primary key constraint on some tables

imp.log:
...
...
. . imported "PROXIMA_DEMO"."ZAYAVKA_ZAKL_ZAKL_RETURN" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
ORA-39083: Object type INDEX failed to create with error:
ORA-14102: only one LOGGING or NOLOGGING clause may be specified
Failing sql is:
CREATE UNIQUE INDEX "PROXIMA_DEMO"."PK_A_DEMOCONTRAGENT#ID" ON "PROXIMA_DEMO"."A_DEMOCONTRAGENT" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING NOCOMPRESS
LOGGING STORAGE( INITIAL 131072 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PROXIMA" PARALLEL 1
...
...

Can anybody explain why so happen?