Skip to Main Content
Forums

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!

Truncate Table

user8686720Nov 15 2010 — edited Nov 15 2010
Hi,

We have table of size approx 100 GB. The time required to truncate this table is around 20mins. While someone mistakenly executed truncate command and immediately killed the session conducting truncate operation. But no data found within the table. This is bit confusing to me that how the data is truncated so fast, since generally this require approx 20 mins.

What happens at the background while a table is truncated?

Thanks for your valuable time.

Regards,
Joy
This post has been answered by sb92075 on Nov 15 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2010
Added on Nov 15 2010
#general-database-discussions
9 comments
428 views