Re: decreasing initial extent

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: Tue, 14 Jan 2003 13:05:22 +0100
Message-ID: <3e23fcaa$0$206$edfadb0f@dread15.news.tele.dk>

"Peter van Rijn" <p.vanrijnREMOVE_at_THISzhew.nl> wrote in message news:v27u50s55or2f8_at_corp.supernews.com...
> alter table <table_name>
> move
> storage(initial <desired size>;
>
> regards,
> Peter
>

Thank you,

Dum question. The Admin Guide has "If the initial extent becomes smaller, the INITIAL value changes to reflect the new size of the initial extent. " in the text on alter table x deallocate unused. How come deallocate does not decrease the initial extent? Because the tablespace is LMT?

/Peter Received on Tue Jan 14 2003 - 06:05:22 CST