How datas can be handled in Big database

From: Fither Muhammed <fither_mNOfiSPAM_at_hotmail.com.invalid>
Date: Tue, 11 Jan 2000 01:29:47 -0800
Message-ID: <00726258.ff885fce_at_usw-ex0110-075.remarq.com>

[Quoted] [Quoted] 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

Received on Tue Jan 11 2000 - 10:29:47 CET

This message: [ Message body ]
Next message: Leszek Kozlowski: "Developer/2000 - operting system?"
Previous message: Craig Ledbetter: "Re: Warehouse Query Tool"
Next in thread: Jan-Peter Meyer: "Re: How datas can be handled in Big database"
Reply: Jan-Peter Meyer: "Re: How datas can be handled in Big database"
Reply: Connor McDonald: "Re: How datas can be handled in Big database"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message