Recently I have encountered this error when I am trying to import data in of our customer server.
Here export was taken using EXPDP and with SYS user and Import with IMPDP using SYSTEM user. Here system can import data unless it has privileges to import data which is exported by SYS user.
There are around 358 objects was not imported and failed with below error.
Starting “SYSTEM”.”SYS_IMPORT_FULL_02″: SYSTEM/******** directory=IMP_DIR dumpfile=TNTX_Tenant_01.dmp REMAP_SCHEMA=TCMP:CALCLD logfile=LOG_DIR:phase2_import.log
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE:”CALCLD”.”CS_xxxxxxxx” failed to create with error:
ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
Failing sql is:
CREATE TABLE “CALCLD”.”CS_xxxxxxxx” (“Txxxxx” VARCHAR2(4 BYTE) DEFAULT user NOT NULL ENABLE, “NAME” VARCHAR2(30 BYTE) NOT NULL ENABLE, “NEXTVALUE” NUMBER(*,0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE “TALLYDATA” PART
ORA-39083: Object type TABLE:”CALCLD”.”CS_xxxxx” failed to create with error:
View original post 29 more words