e ran some tests recently with advanced compression to see how much space it would save us and the impact it would have on performance.
The simple test we ran was:
expdp / directory=DATA_PUMP_DIR schemas=TP_INT flashback_time=systimestamp
to export the test schema out
create tablespace comptest default compress for all operations; -- to create the adv compression tablespace
impdp / remap_schema=TP_INT:COMPTEST remap_tablespace=TPCONS:COMPTEST TRANSFORM=SEGMENT_ATTRIBUTES:n
to then do the import (remapping schema/tablespace) - note the transform option which we need to strip off the default storage syntax which is nocompress and will override the tablespace setting.
The data was compressed from 60GB to 30GB (compression varied from table to table).
The simple test we ran was:
expdp / directory=DATA_PUMP_DIR schemas=TP_INT flashback_time=systimestamp
to export the test schema out
create tablespace comptest default compress for all operations; -- to create the adv compression tablespace
impdp / remap_schema=TP_INT:COMPTEST remap_tablespace=TPCONS:COMPTEST TRANSFORM=SEGMENT_ATTRIBUTES:n
to then do the import (remapping schema/tablespace) - note the transform option which we need to strip off the default storage syntax which is nocompress and will override the tablespace setting.
The data was compressed from 60GB to 30GB (compression varied from table to table).
Do you need license for TRANSFORM=SEGMENT_ATTRIBUTES:n
ReplyDeleteor does it comes under basic?
The transform option is not separately licensed,
Delete