Thursday, July 25, 2013

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


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


Failing sql is:

CREATE TABLE neer.neeraj( empid number,salary number,lname char(10))…….

ORA-39083: Object type TABLE:"MALI_PRT1"."DAILY_C2S_TRANS_DETAILS" 
failed to create with error:

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

impdp system/manager directory=dump dumpfile=emp.dmp logfile=emp.log remap_schema=hr:neer transform=segment_attributes:n parallel=4

Transform parameter allows you to alter object creation DDL while performing import.  I have tried all the attempt to make the understanding of transform parameter easy.
TRANSFORM = transform_name:value[:object_type]
The transform_name specifies the name of the transform. The possible options are as follows:
  SEGMENT_ATTRIBUTES – If the value is specified as y, then segment attributes (physical attributes, storage attributes, tablespaces, and logging) are included, with appropriate DDL. The default is y.
STORAGE - If the value is specified as y, the storage clauses are included, with appropriate DDL. The default is y. This parameter is ignored if SEGMENT_ATTRIBUTES=n.
OID - If the value is specified as n, the assignment of the exported OID during the creation of object tables and types is inhibited. Instead, a new OID is assigned. This can be useful for cloning schemas, but does not affect referenced objects. The default value is y.
PCTSPACE – The value supplied for this transform must be a number greater than zero. It represents the percentage multiplier used to alter extent allocations and the size of data files.
The object_type is optional. If supplied, it designates the object type to which the transform will be applied. If no object type is specified then the transform applies to all valid object types.


No comments:

Post a Comment