-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|