Re: ARCHIVELOG and large number of inserts.

Hi,

Perhaps you can setup another database with noarhive mode turn on to host this table and setup a database link and synonym on top of it.

This will avoid the need to keep so many redo logs as archiving is no longer required. Make use of nologging during insert if possible and use truncate table instead of delete all rows to keep out any unnessary redo entries from being generated.

Clement

Yann Doussot wrote:
>
> 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 Sat Mar 13 1999 - 05:56:18 CST