5 Replies Latest reply: Apr 6, 2012 8:23 AM by Dean Gagne-Oracle RSS

    impdp TRANSFORM for converting table to COMPRESSED  while importing


      Is it possible to convert a table to COMPRESSED using IMPDP TRANSFORM ?
      We are on Oracle 11.2 and licensed for compression and using compression already.
      While refreshing old database with new database with compression, we use expdp/impdp for certain schemas so trying to see if we can covert table to COMPRESSED during impdp itself.
      I could create a compressed tablespace and use remap_tablespace or generate DDL and modify, but having something in impdp itself would be efficient.