| 9i Partitioning options [message #62140] |
Tue, 29 June 2004 08:04  |
Adam
Messages: 15
Registered: October 2001
|
Junior Member |
|
|
Hi,
The documentation talks about the following partion options:
range, hash, list, composite range-hash and composite range-list .
I believe the best option for me would be a composite list - range partition, as my list is small ( three values) and range will be months. So, I partition by list and subpartition by date. Does anyone see a problem here? I ask becuase the documentation does not list this as an option and my test enviroment is not a reliable indication of production.
Thanks for any insight.
Adam
|
|
|
|
| Re: 9i Partitioning options [message #62154 is a reply to message #62140] |
Wed, 30 June 2004 06:08  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
No, that won't work. List-range partitioning isn't supported (don't confuse it with range-list). If I were you, I would partition by range on the date column, then optionally subpartition on the list.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
