Re: How datas can be handled in Big database

Fither Muhammed wrote:
>
> Hi
>
> 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

Look at partitions and read-only tablespaces.

HTH

-- 
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."