Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Locally Managed Tablespaces
why not use system allocation sizes?
extent management local autoallocate
If tables are going to be a variety of different sizes this should work
fine. I use it pretty much everywhere because no one ever has any idea how
big their tables will get.
You danger, no matter what you do is the originator will throw out some wacky initial extent size, like 10Gb and only have one row. Oracle will go with their inital but ignore the next.
Mike
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 20 2005 - 15:25:43 CST
![]() |
![]() |