Oracle: Truncate large table takes forever
2
votes
2
answers
18538
views
Problem
-------
- I'm truncating a very large table ( 210+ million rows ).
- It's been hours since it started and I have no idea when it will be done.
- There're several tables like that, that I want to truncate.
- The database is Ora9i.
Question
--------
- **How can I do to make truncates faster ?**
- Also, Is there a way to see the progress of the truncate operation ?
Asked by Tulains Córdova
(723 rep)
Sep 16, 2013, 06:05 PM
Last activity: Jul 27, 2017, 11:36 PM
Last activity: Jul 27, 2017, 11:36 PM