Hi All,

I have a table which might have upto a 100 million records in a year. It has a date column and I need to have 12 partitions for this table, one for each month.

These partitions need to be such that records having date of January should get inserted into the "JAN" partition irrespective of the year of the date.

For example: Records with 31-Jan-2001 and 01-Jan-2003 as dates should both get inserted into the JAN partition.
Similarly for records belonging to Feb and the rest.

I am working on 9i and I want to avoid adding an extra column to the table corresponding to the month name or number.

Any pointers on this would be of great help.

Thanks in advance!