With Oracle 7.3.3 we see exactly the behaviour you describe.
TRUNCATE causes the physical storage parameters to revert to those
specified when the table was created - any modifications made since
creation with ALTER TABLE are lost.
David J. Hazledine
Roche Products Limited
40 Broadwater Road
Welwyn Garden City
AL7 3AY
United Kingdom
Registration Number 100674
Tel. +44 (0)1707 366166
--
Posted via Talkway - http://www.talkway.com
Exchange ideas on practically anything (tm).
Received on Wed May 12 1999 - 10:01:14 CDT
