Re: ARCHIVELOG and large number of inserts.

Hi,

yes: create table .... unrecoverable;

no redo's will be written.

Torsten

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 Fri Mar 12 1999 - 09:59:04 CST