Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Partition
DaFT wrote:
> In fact I receive a lot of information (+/-1.000.000 record) per
> week...
> Each week are in a partition...
> And when I must do a research to a date, I determine the partition and
> I search on it...
> But for the old value, all the records are on the same partition...
>
> Thanks for the solution ;)
That is, to use your own name, daft. The entire point of partitioning is that you don't have to care in which partition Oracle put the record. Is there some other reason you are doing all this work?
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Fri Jan 13 2006 - 12:30:10 CST