nviado el: Tuesday, November 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 cre
ate.nc.us>cc:
Sent by: Subject: Re: Partition Question
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 a
Hi List,
I have a question regarding partitioning: If I want to partition a table
which strategy is better, like do i have to use a value which from first day
of using this table all those partion is using or just using first partion,
then second etc.
E.G:
If I do partion tableA based on ID range
