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

Satar Naghshineh <satarnag_at_worldsite.com> 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

Only if you want to delete all of the rows in a table. The syntax is TRUNCATE TABLE tablename;

--
Chuck Hamilton
Sr. DBA
Keystone Mercy Health Plan
chuckh_at_dvol.com

"So teach us to number our days that we may present to thee a heart of wisdom"
(Psalm 90:12 NASB)