5 Replies Latest reply: Dec 5, 2012 3:13 AM by 793996 RSS

    Adding new LIST partition

    793996
      Hi All,

      I'm using Oracle 11g R2 and have an existing table with 3-list Partitions.

      CREATE TABLE parts_tbl
      (id char(10),
      name varchar2(500),
      type number
      )
      PARTITION BY LIST(type)
      (PARTITION part_t1 VALUES (1),
      PARTITION part_t2 VALUES (2),
      PARTITION part_t3 VALUES (3)
      );

      Is it possible to ALTER the table to add a new list partition for value 4?

      Thanks,
      Vivek