05, 2002 4:09 PM
Para: Multiple recipients of list ORACLE-L
Asunto: Re: Partition Question
I agree...
What are you trying to accomplish with partitioning? Partitioning by year
/ month / day / whatever can make it easy to truncate / archive old data.
The only trick is to create new partitions
cc:
Sent by: Subject: Re: Partition Question
[EMAIL PROTECTED
It depends on your reason for partitioning -- if you mean to drop a partition in
the future (to roll off the 1999 data or whatever) then the ID range is
potentially a valid approach, as long as ID is serial. If you just want to put
chunks on different disk volumes, you could use the type or even