I'm using Oracle 11g R2 and have an existing table with 3-list Partitions.
CREATE TABLE parts_tbl
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?
I have tried this and it is showing my partition in USER_TAB_PARTITIONS as well.
What actually confusing me is the fact that i have nowhere specified the column-name. So how can it be assured (without adding actual data) that the new partition created is LIST and on the column i want?
Is there any Data dictionary table where i can see column-partition mapping?