Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle tablespace/table compression during import

Status
Not open for further replies.

JtheRipper

IS-IT--Management
Oct 4, 2002
274
GB
Hi there,

I created a compressed tablespace with an empty compressed partitioned table in database B. I exported the data from database A (uncompressed) and imported it into database B, but when I looked the data in database B was not compressed ? Any ideas on why oracle would not compress the data during an import? I had to import the data into another table, then perform a "insert into select..." to get the data compressed.

Thanks,
J.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top