Re: adding a partition to a list partitioned table.

In your create table ddl, you get an index automatically when designating a primary key. By adding the 2005 partition it rendered the primary key index (sys_c005405) unusable. Rebuild the index and your problem will be solved.

p.s. Ignore anything DA Morgan says. He's a very negative person and rarely provides any useful answers and instead seems intent on belittling posters of this forum. Received on Wed Nov 16 2005 - 12:59:20 CST