Re: Truncate changes NEXT allocation?

From: Kevin Kubek <kkubek_at_hotmail.com>
Date: Wed, 12 May 1999 15:20:57 GMT
Message-ID: <7hc68h$8ml$1@nnrp1.deja.com>

In article <7hbs95$m8i$2_at_m2.c2.telstra-mm.net.au>, "Nuno Souto" <nsouto_at_nsw.bigpond.net.au> wrote:

> 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.
>

I can verify that this is the behavior in 8.0.4, but only if you: TRUNCATE tabname DROP STORAGE

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 12 1999 - 10:20:57 CDT