Data Compression: exp and imp vs expdp and impdp
Issue:
I am seeking confirmation that I cannot compress data (merge extents) with data pump until 11g
Background:
The docs on datapump indicate:
"There is no option to merge extents when you re-create tables. In original Import, this was provided by the COMPRESS parameter. Instead, extents are reallocated according to storage parameters for the target table."
"If a table has compression enabled, Data Pump Import attempts to compress the data being loaded. Whereas, the original Import utility loaded data in such a way that if a even table had compression enabled, the data was not compressed upon import"
0