Re: locally managed tablespace

No you don't.

The next and pctincrease will be ignored. The initial will be used to determine how many extents of 128K will be allocated. For example if you set INITIAL 500K, then you would find that the table had been allocated 4 extents of 128K.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



sp wrote in message ...


>when we create a uniform extent locally managed tablespace with the

>following command, don't we need to use storage clause

>(initial,next,pctincrease) with the create table command?

>CREATE TABLESPACE lmtbsb DATAFILE '/u02/oracle/data/lmtbsb01.dbf' SIZE 50M

>    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;

>thanks in advance.

>SP

>

>