Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Partition
"DaFT" <gbaland_at_gmail.com> wrote in message
news:1137154570.786332.149490_at_g14g2000cwa.googlegroups.com...
> 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 ;)
>
alter table add column godina and
try to make partition over week and year...
Received on Fri Jan 13 2006 - 07:58:51 CST