Re: Using truncate partition on running table!!

From: David Aldridge <slimdave_at_yahoo.com>
Date: 8 Mar 2005 10:59:38 -0800
Message-ID: <1110308378.762091.69420@o13g2000cwo.googlegroups.com>

If that is a global index then the partition truncation will have made it unusable. If your version supports the syntax, then use "update global indexes" to keep them maintained. Otherwise you'll have to use local indexes or use a delete to remove the rows. Received on Tue Mar 08 2005 - 12:59:38 CST