Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> truncate a table with many extents
I'm truncating a table with around 14,000 extents
on a 7.3.4 database on a slow machine.
(Please don't ask how this happened, it's too=20
painful to re-live.)
Is there anyway to determine how far the truncate has gotten at any given point? I thought I might see changes in sys.fet$ or sys.uet$ as extents are de-allocated, but I'm not seeing that.