This discussion is archived
4 Replies Latest reply: Oct 9, 2012 11:06 AM by Marc Fielding RSS

Create Table As and Hybrid Columnar Compression

user154136 Newbie
Currently Being Moderated
I am looking to join for tables together using create table as and I had a question about Hybrid Columnar Compression. For testing, I have found that the uncompressed daata will be around 10 TB and the compressed data will be around 1 TB. I am planning to compress the table during the create table as statement and wanted to know in what order Oracle whould do the compression, i.e. will the table be created and then Oracle will compress the data or will the table be compressed as the table will be created. The motivation behind the question is to see how much storage I will need to complete the operation.

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points