Dear all,
Have requirement to compress data during impdp process(for entire schema). Doint data-only import.
Version: oracle 12cr2.
Performed:
- Altered every table to include compress using: ALTER TABLE TABLE_NAME ROW STORE COMPRESS BASIC;(also tried ROW STORE COMPRESS ADVANCED)
- while doing impdp included another parameter: TRANSFORM=TABLE_COMPRESSION_CLAUSE:\"ROW STORE COMPRESS ADVANCED\"
- Noted size of schema before compression
- Calculated size of schema after above compression setting and compared, i do not see any difference and is same.
Am i missing anything..? or anyother parameters to be looked into it?
Also tried tablespace compression by altering it, alogn with table level.
Pls suggest, your inputs are valuable.
Regards,
KK.