Truncate changes NEXT allocation?

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au>
Date: Wed, 12 May 1999 21:51:25 +1000
Message-ID: <7hbs95$m8i$2@m2.c2.telstra-mm.net.au>

As the title says.

Someone I know maintains this is true. I've tried it and it doesn't. Is there any version of ORACLE where this may happen?

Basically, if a table has eg INITIAL 1M NEXT 1M, then you change via ALTER to NEXT 10M, this guy maintains that a truncate will reset NEXT to 1M. I've verified that in normal conditions it doesn't, so I need to know of any "abnormals", if any.

TIA for any info on this. Go via e-mail if your newsfeed is not very reliable, I find it easier.

--
Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au
http://www.acay.com.au/~nsouto/welcome.htm Received on Wed May 12 1999 - 06:51:25 CDT