ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

I face with ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified error message during making Export table from 11.2.0.2 RAC database to 11.2.0.1 RAC database on AIX 6.1.

My export command is:

expdp user/password@SID tables=Myschema.XXX,Myschema.YYY directory=EXPDP_DIR DUMPFILE=dump2%U.dmp PARALLEL=3 logfile=MyExport.log

My Import command is:

impdp user/password@SID2 directory=impdp_dir dumpfile=dump2%U.dmp REMAP_SCHEMA=Myschema:Newschema remap_tablespace=MyschemaTs01:NewTs01 TABLE_EXISTS_ACTION=APPEND logfile=MyImport.log

The error message is:

Failing sql is:
CREATE TABLE “Newschema”.”XXX” (“HEADER_ID” VARCHAR2(30 CHAR), “LINE_NUMBER” NUMBER(20,0), “ACCOUNT” VARCHAR2(15 CHAR),
ORA-39083: Object type TABLE:”Newschema”.”XXX” failed to create with error:
ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
Failing sql is:
CREATE TABLE “Newschema”.”XXX” (“HEADER_ID” VARCHAR2(30 CHAR), “BRANCH_NAME” VARCHAR2(4 CHAR),
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object “Newschema”.”XXX”:”P20120410″ failed to load/unload and is being skipped due to error:
ORA-00942: table or view does not exist

Solution:

impdp user/password@SID2 directory=imp_dir dumpfile=dump2%U.dmp REMAP_SCHEMA=Myschema:Newschema remap_tablespace=MyschemaTs01:NewTs01 TABLE_EXISTS_ACTION=APPEND transform=segment_attributes:n logfile=MyImport.log


About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: