help in partitions

[Jeya]

Dears


I partitioned a table for storing the data pertaining to year and months. But initially the partition is from 1999 onwards.

Now i need to populate the data for 1998. I tried to create a partition for 1998, which smashed me with error. It says
PARTITIONS CAN BE CREATED IN HIGHER ORDER.

How to create or to alter partitions for previous values.

Help me out! urgent!


Regards


Jeyachandran.P

[sarathik]

you cannot add new partiion with values lesser than already present.
However in your case you need to split the exisiting partition(1999) to include the new partition for 1998.

They synax would be :
alter table test_dummy
split partition p_1999 at (1999)
into (partition p_1998, partition p_1999);

[Jeya]

Dears,


I am having a small doubt. I need twelve partitions for 1998. I am already having partitions for months 1999 jan to 2001 dec. How can i split the partition to accomodate 1998. Is it possible to split a single partition ( say year199901) to (year199801,year199802....year199812). into thirteen partitions.

If i can, what would be the nature of the partition, which i splitted. What data it will hold?

Will it affect performance ?



Regards

Jeyachandran.P