Hi All,

I have a table in which we are storing date column( Column name is process_date) as varchar2(6) in 'YYMMDD' Format. As to improve our database performance i am looking to implement partition concept.

At any point of time we need to keep four months of data in our database. Suppose this is Mar month we are having Dec,jan,Feb and Mar months data ( basing on process_Date).

Now i am looking to implement partitions.

I need the Partitions like...

P1 contains 1st, 4th, 7th, 10 th Months data

p2 Contains 2nd, 5th, 8th, 11 ths Months data

p3 Contains 3rd, 6th, 9th, 12 ths Months Data.

Please help me how to implement these partition concepts.

Thankx and Regards,
Sekhar