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

11g에서 impdp를 사용시 발생하는 에러

원래의 segment 절을 사용용 할 수 없어 발생 

TRANSFORM=SEGMENT_ATTRIBUTES:N

옵션을 추가 하여 해결

예는 아래...

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":  system/******** dumpfile=PUMP_DIR:TLO.dmp logfile=PUMP_DIR:TLO.log schemas=HR, SCOTT, SH, TLO remap_tablespace=EXAMPLE:USERS  Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/TABLE/TABLE ORA-39083: Object type TABLE:"SH"."SALES" failed to create with error: ORA-14102: only one LOGGING or NOLOGGING clause may be specified Failing sql is: CREATE TABLE "SH"."SALES" ("PROD_ID" NUMBER NOT NULL ENABLE, "CUST_ID" NUMBER NOT NULL ENABLE, "TIME_ID" DATE NOT NULL ENABLE, "CHANNEL_ID" NUMBER NOT NULL ENABLE, "PROMO_ID" NUMBER NOT NULL ENABLE, "QUANTITY_SOLD" NUMBER(10,2) NOT NULL ENABLE, "AMOUNT_SOLD" NUMBER(10,2) NOT NULL ENABLE) PCTFREE 5 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS  NOLOGGING  S ORA-39083: Object type TABLE:"SH"."COSTS" failed to create with error: ORA-14102: only one LOGGING or NOLOGGING clause may be specified Failing sql is: CREATE TABLE "SH"."COSTS" ("PROD_ID" NUMBER NOT NULL ENABLE, "TIME_ID" DATE NOT NULL ENABLE, "PROMO_ID" NUMBER NOT NULL ENABLE, "CHANNEL_ID" NUMBER NOT NULL ENABLE, "UNIT_COST" NUMBER(10,2) NOT NULL ENABLE, "UNIT_PRICE" NUMBER(10,2) NOT NULL ENABLE) PCTFREE 5 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS  NOLOGGING  STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE ORA-39083: Object type TABLE:"TLO"."SALES" failed to create with error: ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified Failing sql is: CREATE TABLE "TLO"."SALES" ("PROD_ID" NUMBER NOT NULL ENABLE, "CUST_ID" NUMBER NOT NULL ENABLE, "TIME_ID" DATE NOT NULL ENABLE, "CHANNEL_ID" NUMBER NOT NULL ENABLE, "PROMO_ID" NUMBER NOT NULL ENABLE, "QUANTITY_SOLD" NUMBER(10,2) NOT NULL ENABLE, "AMOUNT_SOLD" NUMBER(10,2) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255  STORAGE( BUFFER_PO Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "SH"."CUSTOMERS"                            9.853 MB   55500 rows . . imported "TLO"."CUSTOMERS"                           9.853 MB   55500 rows . . imported "SH"."SUPPLEMENTARY_DEMOGRAPHICS"           697.3 KB    4500 rows