This discussion is archived
2 Replies Latest reply: Jun 6, 2012 9:25 PM by baskar.l RSS

Few doubts

baskar.l Pro
Currently Being Moderated
Hi All,

Greetings of the day. DB version is 11.2.0.2. Am trying to compress a big table which has lot of partitions.

Create test as select * from original_table - This creates table with data but the ddl of the test table shows without partitions.

How do i create the same table with all the paritions with CTAS?

Baskar.l

Legend

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