Re: DELETE vs TRUNCATE

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 6 Feb 2002 18:47:03 +0100
Message-ID: <u6393s8kgpa0bb@corp.supernews.com>

"Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message news:a3rof4$458u$3_at_as201.hinet.hr...
> What is the difference between DELETE and TRUNCATE SQL commands? What's
> about indicies of tables which content is emptied by those commands?
>
> --
>
> Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
>
>
>

DELETE                        TRUNCATE
DML                              DDL
redo generated                no redo generated
where clause possible      all records deleted
highwater mark not reset  highwater mark reset
not committed automatically (as it is DML)     committed automatically (as

it is DDL)

etc, etc
Obviously this is a doc question.
You are very often asking doc questions. Could you please at least *try* to read them or visit tahiti.oracle.com for searchable docs?
Could you also *please* avoid both *cross* and *multi* posting?

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Wed Feb 06 2002 - 11:47:03 CST