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: 65155
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: Join Statement
Goto Forum:

Current Time: Wed Aug 23 20:21:22 CDT 2017

Total time taken to generate the page: 0.04971 seconds