Home » SQL & PL/SQL » SQL & PL/SQL » Truncate 1000 tables (Oracle 10g RAC)
Truncate 1000 tables [message #358559] Tue, 11 November 2008 20:35 Go to next message
Messages: 13
Registered: May 2008
Junior Member
What is the best way to truncate 1000 tables at a time ? Most of the table are of INITIAL size of 14M each. Also, some of the table contains CLOB column. We found that truncate all take more than 15 minutes. Any way to improve the speed ? We also tried the reuse storage, but the effect is not so obvious. Any advice ?
Re: Truncate 1000 tables [message #358637 is a reply to message #358559] Wed, 12 November 2008 00:53 Go to previous message
Michel Cadot
Messages: 64603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way to speed up truncate which requires to checkpoint each object which is an expensive operation especially in RAC.
15 minutes is quite good for 1000 tables.

Previous Topic: Bulk collect or Cursor
Next Topic: Reading mail from outlook
Goto Forum:

Current Time: Fri Mar 24 07:07:40 CDT 2017

Total time taken to generate the page: 0.14166 seconds