Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Importing into a compressed table

441846Aug 27 2007 — edited Aug 28 2007
Is importing into a compressed table effective?
I mean is data get compressed when using imp utility to load into a compressed table?

from the oracle doc :
Compression occurs while data is being bulk inserted or bulk loaded. These operations include:
·Direct Path SQL*Loader
·CREATE TABLE … AS SELECT statement
·Parallel INSERT (or serial INSERT with an APPEND hint) statement
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 25 2007
Added on Aug 27 2007
2 comments
702 views