|
|
Re: What Hapens to Index When I Truncate the source Table [message #20140 is a reply to message #20137] |
Wed, 01 May 2002 04:46 |
Lakshmi narasimhan
Messages: 2 Registered: May 2002
|
Junior Member |
|
|
If a table has been truncated - index also will truncate. Ie means High Water mark will be resetted.
If A table dropped, then index will dropped.
If few rows of a table deleted, the HWM will be available. If some rows inserted which has the same key like prev existing, it will use the same segment or in case of new keys, it will insert after HWM.
|
|
|
Re: What Hapens to Index When I Truncate the source Table [message #20157 is a reply to message #20137] |
Thu, 02 May 2002 10:54 |
sridhar
Messages: 119 Registered: December 2001
|
Senior Member |
|
|
What I meant by 'does not disturb indexes' meaning TRUNCATE does not drop them. I also said, what TRUNCATE does, "it flushes the data and resets and high water mark". Safer usage of TRUNCATE to keep the same storage would be,
TRUNCATE tableA reuse storage;
Further more on TRUNCATE,
Any enabled foreign keys pointing the table being truncated, should be disabled, otherwise TRUNCATE would fail.
I think this is pretty much enuf for this question,
Thx,
SriDHAR
|
|
|