Subject: Re: DELETE COMMAND
Newsgroups: comp.databases.oracle.misc
References: <34193E02.C1F327BD@djttd.com>
Organization: InterAccess, Co. - Chicagoland's Full Service Internet Provider
Reply-To: akaplan@interaccess.com
Distribution:
vishal (vdoshi@djttd.com) wrote:
: 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@torfree.net
: vishal
:
Vishal,
Use the TRUNCATE command. This will skip all triggers, rollback segments,
redo logs, etc.
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 105+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page