add a partition to a range-partitioned table with local and globa

Hello Gurus,

I need to add a 2002 partition to a range-partitioned table in v8.1.6 on AIX RS6000 platform, v4.3.2. Our table has both local and global-partitioned indexes on it, and our fiscal year begins in July. I'm looking through the online documentation, and I think I need to drop all the indexes, use the syntax:

ALTER TABLE sales

      ADD PARTITION 2002 VALUES GREATER THAN ( '01-JUL-2000' )
      TABLESPACE mytablespace;

to add the new partition (last partition was 2001), then recreate the indexes.

Would it be possible for someone to verify this? Would it be better if I used the 'SPLIT PARTITION' syntax? Oracle says to use this when adding partitions to the "high" end, but I'm not sure if that means first or last. This table is in our data warehouse, and to me the "highest" partition would be the 2002 partition, and the lowest would be the 1994 partition. I did this so old data "purges" (data must be kept for 7 years) would just be a dropping of the lowest partition.

Last one: if I had a mix of local, global-partitioned and global indexes, would I be able to keep the global indexes and just drop the local and global-partitioned indexes (this is out of curiosity)?  

Thanks in advance!
Theresa Crowe Received on Wed Aug 16 2000 - 13:37:44 CDT