Database Utilities (MOSC)

MOSC Banner

Data Compression: exp and imp vs expdp and impdp

edited Apr 25, 2011 3:15AM in Database Utilities (MOSC) 7 commentsAnswered ✓
Issue:
I am seeking confirmation that I cannot compress data (merge extents) with data pump until 11g

Background:

I would like to merge extents (compress data) for a table.  To do so I can use exp or expdp and have 10.2 only at my disposal.

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"

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