ARCHIVELOG and large number of inserts.

From: Yann Doussot <doussot_at_gifrance.com>
Date: 12 Mar 1999 14:52:34 GMT
Message-ID: <slrn7eial3.pt6.doussot@proxima.gifrance.com>

Hello,

I'm using Oracle 8.05 (standard edition) and seeking some help on backup strategy. I want my DB avaible 24H/24, so according to the docs, the only solution for me is to use ARCHIVELOG mode and hot backup. But, once a day, I fill DB with ~1.000.000 lines, do lot of updates, queries, ... and then delete the whole table. These operations generate a lot of redo log files. Datas used is this temporary table are not critical, I can afford to loose them.

So my question is: is a way to completely disable logging for a table (or tablespace) ? I've read docs carefully and the answers seems to be "no". Any ideas ?

Thanks.

--
Yann Doussot Received on Fri Mar 12 1999 - 08:52:34 CST