Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what happens when truncate statement execution is cancelled

838550Feb 19 2011 — edited Feb 20 2011

Hi all,

I executed Truncate table statement in TOAD by mistake and cancelled the execution immediately,
now I can see that table does have records in it,
what exactly has happened? when does the statement get executed? at the end ,after it deleted all the rows ?or after deleting each record?

This post has been answered by sb92075 on Feb 20 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 20 2011

Added on Feb 19 2011

#general-database-discussions, #oracle

8 comments

966 views