Importing into a compressed table
441846Aug 27 2007 — edited Aug 28 2007Is 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