2 Replies Latest reply: Jun 6, 2012 11:25 PM by baskar.l RSS

    Few doubts

    baskar.l
      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