-
Table Partitioning
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!
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
|