Re: DELETE COMMAND

From: Anon <pjbump_at_i1.net>
Date: 1997/09/20
Message-ID: <01bcc5e5$b14c94e0$d33ae6cf@default>#1/1

The command is TRUNCATE TABLE tablename; This bypasses the redo log file write, but is unrecoverable. Use with great caution.

Phillip Bump
pbump_at_us.oracle.com

vishal <vdoshi_at_djttd.com> wrote in article <34193E02.C1F327BD_at_djttd.com>...
> Hi,
> Does anybody know about the DELETE command where when you issue a
> delete * from table it does not go into the rollback segment but gets
> deleted
> immediately and cannot be recovered.
>
> thanx
>
> Please email me.
> bu756_at_torfree.net
>
> vishal
>
>
Received on Sat Sep 20 1997 - 00:00:00 CDT