Look up global temporary tables and see if that fits the bill for what you
are doing. They don't get logged.
Jim
"Andrei Romazanov" <romazanov.andrei_at_gfos.de> wrote in message
news:atq0qs$1gm52$1_at_ID-70985.news.dfncis.de...
> Hi,
>
> is subj. possible? I have a table with temporary data, that are inserted
and
> deleted relatively often. I want to prevent redo logs for this
transactions.
> I've tried with NOLOGGING attribute, but it did not have any effect. Now I
> know , that only some operations can make use of the NOLOGGING option,
not
> INSERT or DELETE.
>
> Does someone have a idea?
>
> Thank you in advance
> Andrei
>
>
Received on Wed Dec 18 2002 - 08:52:36 CST
