Re: adding a partition to a list partitioned table.

mail2atulmehta_at_yahoo.com wrote:
> That is what I am confused about as well. I have not craeted any index.
> I did the last alter statement, as the error was about the index.

It is always far more helpful when you include the full error message rather than your interpretation of it.

Time to do some research:

all_ind_partitions
all_ind_subpartitions
all_indexes

The answer is there. You'll need to dig for it.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)