Re: deleteing w/o going through the redo log files?

Satar Naghshineh wrote:
>
> Hi..quick question,
> Is it possible to delete rows from a table w/o going through the redo
> log groups/files/buffers? If so, what is the syntax.
>
> I think it was something like recovery = false I forget/don't know
>
> any help will be appreciated
>
> Satar Naghshineh
> SatarNag_at_worldsite

There is an interesting init.ora parameter (for "interesting" read "asking for trouble") which lets you disable all logging on the database but I think you need the "all-clear" from Oracle WWS before you use it...

Cheers
C.

-- 
---------------------------------------------
Connor McDonald
BHP Information Technology
Perth
Australia
email: mcdonald.connor.cs_at_bhp.com.au
"My views are not BHP ...blah blah"
---------------------------------------------
"Opera singers are the only people that when you 
 stick a knife in them, they sing, not bleed"