This discussion is archived
5 Replies Latest reply: Dec 5, 2012 1:13 AM by 793996 RSS

Adding new LIST partition

793996 Explorer
Currently Being Moderated
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

Legend

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