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

    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