Re: Do LMT's ignore initial & next parameters in the storage clause?

Ben wrote:
> 9.2.0.5 Ent Ed.
> I create a locally managed tablespace with uniform/manual extent
> allocation set to 1M. Then I create an index or table in that LMT but
> include a storage clause with initial set to 20M and next set to 1M.
> Are these parameters ignored and instead the object has 1M extent
> sizes? I believe I already know the answer, as I have done this and it
> looks as though this is true, but I didn't understand why it would let
> you set those values in the storage clause and then ignore them.

Yes. See
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:409670433426 and poke around on dizwell.com for details.

They are there for historical/compatibility reasons.

jg

--
@home.com is bogus.
http://www.usatoday.com/tech/products/cnet/2006-10-27-oracle-red-hat_x.htm