impdp on partitioned tables creates different compression than source
source: RDMBS 11.1.0.7
target: RDBMS 12.1.0.2
I am using impdp to migrate a schema that has partitioned tables.
In the source, the table was originally created with sql like this (I've truncated it because it's quite long, but notice the COMPRESS FOR DIRECT_LOAD OPERATIONS
CREATE TABLE "NEXRAD"."NEXRAD_NONZERO"
( "FEATURE_ID" NUMBER (10),
"TSDATETIME_DT" DATE,
"TSVALUE_MS" NUMBER (25, 3),
"LASTUPDATE_DT" DATE
) TABLESPACE "NEXRAD"
NOLOGGING
COMPRESS FOR DIRECT_LOAD OPERATIONS
.... and so on
When I performed the impdp, the table came in as COMPRESS BASIC. A dbms_metadata.get_ddl, like so:
Also impdp to a sqlfile looks like this.
CREATE TABLE "NEXRAD"."NEXRAD_NONZERO"