Oracle IMPDP Import Database report ora-14460 error

Database version:

SOURCE Library: 11.2.0.4

Destination Library: 11.2.0.1

The operation is as follows:

When importing the source library EXPDP data into the destination library, there is a partitioned report with the following error

Ora-14460:only one COMPRESS or nocompress clause may be specified

Workaround:

The IMPDP command plus the TRANSFORM=SEGMENT_ATTRIBUTES:N parameter can be

IMPDP Username/password Directory=impdp_dir dumpfile=*.dmp transform=segment_attributes:n

The above statement indicates that the existing stored properties of any table are not imported when importing

Description: Transform_name has four options: Segment Attributes,storage,oid,pctspace

--segment attributes: Segment properties include physical properties, storage properties, table spaces, and logs.

--storage: You can use the Storage=y (default) description to take only the stored properties of an object as part of the import job.

--oid: If you specify Oid=y (default), a new OID is assigned to the object table during the import process.

--pctspace: You can increase the allocation size of an object by providing a positive number as the value of the conversion, and the data file size is equal to the value of pctspace (by percentage)

Value:transform_name value, Transform_name is segment attributes,storage,oid value can be y/n,pctspace

Object_type values can be tables, indexes, table spaces, types, clusters, constraints, and so on.

Oracle IMPDP Import Database report ora-14460 error