Re: Deleting 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

   yes - two ways - one if you want to get rid of all the rows use the truncate command. .i.e. truncate table emp; two use the create table unrecoverable option. and create a table with data you want and truncate the old. Received on Fri Sep 05 1997 - 00:00:00 CDT