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!

How to fix ORA-14102: only one LOGGING or NOLOGGING clause may be specified

626620Apr 27 2010 — edited Sep 5 2012

I exported a schema from 11g2 and import to the same database using commands

expdp BI/pass@tdev2 schemas=QAPF directory=DATA_PUMP_DIR EXCLUDE=STATISTICS parallel=6 dumpfile=bistg_qapf_%U.dmp logfile=bistg_qapf.log
impdp BI/pass@tdev2 remap_schema=QAPF:QAPF2 remap_tablespace=CCH_DATA:CCH2_DATA directory=DATA_PUMP_DIR parallel=6 dumpfile=bistg_qapf_%U.dmp logfile=qapf2__imp.log

I got error

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 "QAPF2"."ORG_X_PHONE_I0" ON "QAPF2"."ORG_X_PHONE" ("ORG_ID", "PHONE_ID") PCTFREE 10 INITRAN
S 2 MAXTRANS 255 NOLOGGING NOCOMPRESS LOGGING TABLESPACE "CCH2_DATA" PARALLEL 1

There are hundreds of these errors.

There are couple of threads in the forum working around this problem by using sqlfile option to create a sql file and edit the code manually. But is wrong in the commands or in datapump that cause the problem. I really want datapumpdoes it job properly, instead of work around by manually fix code.

Thanks