2 Replies Latest reply on Jun 7, 2012 4:25 AM by baskar.l

    Few doubts

      Hi All,

      Greetings of the day. DB version is 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?