Re: Administration of historical records

How the record can be transfert from one segment table to a other after X days automaticly. Is there a option in oracle 81 that can do this job or i have to code a application to transfert the records from one segment ot a other.

Ron

"Alexander Medvedev" <a.medvedev_at_globalone.ru> a ecrit dans le message news: 3A30A0AE.74A1F695_at_globalone.ru...
>
>
> Ronald Berube wrote:
>
> > Is there a way, with the new version of oracle 8i, to manage the
 historic of
> > the record in a database. In a orther way, is there a way we can
 extract
> > records from tables online and put it in a other depot (historic) where
 it
> > can be recall when we need it. In this situation the online table can
 be
> > more efficient (less records) 98 % of the request and restore the
 record
> > from historic on special demand without changing the query (access only
 in
> > primary table in the query, not the historic).
> >
> > Thank's
> >
> > Ron
>
> Hi Ron,
>
> Only you need is a partitioning by date key. Another solution is a
 materialized
> view.
>
> Regards Alexander Medvedev
>
Received on Fri Dec 08 2000 - 14:33:39 CET