Adding a partition to a range-partitioned table

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? Oralce 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.  

Thanks much! Received on Wed Aug 16 2000 - 11:46:49 CDT