Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Truncate Table?

Truncate Table?

From: ccdicky <ccdicky_at_yahoo.com>
Date: Fri, 19 Nov 1999 01:18:00 +0800
Message-ID: <811ccj$68618@imsp212.netvigator.com>


Hi,

Truncating tables can reset their HWMs. But how about their indexes? That is, the indexes belonging to the truncated table are cleaned up, just like "Rebuild" or "Drop and Create".

Any pointer would be greatly appreicated.

Dicky Received on Thu Nov 18 1999 - 11:18:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US