| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: How datas can be handled in Big database
Use partitioning of tables.
You can split tables into partitions in case of contents of a field.
In your case you can say that records older 6 month -> partition "old"...
Please read the Oracle Doku "Partitioning tables".
Its very easy.
Fither Muhammed wrote:
> We want to manage a database containing more than 1 GB
> data. The data base containing 54 tables. In this database
> most of the space is occupied by 5 tables. Only the datas
> of the last six months are needed for usual operations. But
> the data before Six months are needed for annual reports.
> Can we improve the performance by taking the backup of old
> records(before six months) and delete the same from the
> database ? Can we restore the old data from this back up
> if there is a need for that? What are the
> Techiniques/Methods used for this ?
>
> We are using NT4.0/ORACLE 8
>
> Thanks - Fither Muhammed
>
> * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
--
 |
 |