Re: DELETE COMMAND

From: Dan Clamage <clamage_at_mime.dw.lucent.com>
Date: 1997/09/17
Message-ID: <01bcc37a$d8b135d0$54110b87@clamagent>#1/1

Yeah it's called truncate. There's a stored procedure in one of the Oracle-supplied packages that implements it but I forget which package (and what the procedure is called-- probably something with "trunc" in it). - Dan Clamage

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 Wed Sep 17 1997 - 00:00:00 CDT