Database Utilities (MOSC)

MOSC Banner

impdp on partitioned tables creates different compression than source

edited Oct 17, 2014 10:01AM in Database Utilities (MOSC) 4 commentsAnswered

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"                                                                                           

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center