RE: Locally Managed Tablespaces

If you have a locally managed tablespace, you don't need to bother with specifying the INITIAL, NEXT, MINEXTENTS, PCTINCREASE storage parameters. You can specify them, and Oracle will initially allocate as many extents as it needs to satisfy the storage parameters, but there's no advantage in doing so unless you want to make sure that your table has space "pre-reserved."  

e.g. locally managed tablespace uniform extent size 1M create table x (...) storage (initial 10M next 20M minextents 5) You have asked for 5 extents, 1 of 10M and 4 of 20M for a total of 90M. Your table will be created with 90 1M extents. After that Oracle will allocate 1M extents as needed - the NEXT parameter will be ignored from now on.

-----Original Message-----

Smith, Ron L.

We are upgrading an application that uses an external database to set=20 initial table create parameters. =20
I would like to use Locally Manages tablespaces and Uniform extent=20 sizes, instead of the table create parameters.=20

My question is, will Locally Manages tablespaces cause Oracle to ignore=20
the table create parameters? (I hope)=20 And, if I have some tables that are empty, and some that have a million=20
rows, what do I use for an initial extent size?=20 Do I allocate them all small and let the large tables go into extents?=20

I don't have the luxury of putting large tables in a separate=20 tablespace. Everything is in one schema and one tablespace.=20

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 20 2005 - 15:35:15 CST