Buy Jonathan's book ! (Practical Oracle 8i)
"Ragnar Hark" <ragnar.hark_at_mail.ee> wrote in message
news:b6c80k$jl5$1_at_kadri.ut.ee...
> "Guido Konsolke" <Guido.Konsolke_at_triaton.com> wrote in message
> news:1049199121.332966_at_news.thyssen.com...
> > "Ragnar Hark" wrote...
> > > Hi all !
> > >
> > > What is a best way to partition already existing table ?
> > >
> > > For example;
> > > I have a table which contains about 80000000 rows and
> > > each row contains timestamp. So, I think the best solution
> > > is partition data by months.
> > >
> > > sorry, if this message send twice
> > > ragnar.hark_at_mail.ee
> > >
> > Hi Ragnar,
> >
> > what time span do the data cover? What are the usual queries
> > that are used (where clause)? Give us a little more information.
>
> Table contains rows through 6 months, but major mass of queries
> runs only on the last month data.
>
>
Received on Tue Apr 01 2003 - 08:55:25 CST
