Re: TRUNCATE ???

Andreas,

No you are not being silly, the default behaviour of TRUNCATE (drop storage) is to reset NEXT to the value of the last extent deleted, thereby overwriting any alter table... statements you may have issued. There are 2 alternative ways around this;

1. use the REUSE STORAGE option (but would leave many extents)
2. issue the alter table ... command AFTER truncating the table.

Incidentally, there is an enhancement request 502098 to alter this behaviour to what you would expect.

Regards,

Ian Received on Fri Nov 07 1997 - 00:00:00 CST