Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Locally Managed Tablespaces

Re: Locally Managed Tablespaces

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Thu, 20 Jan 2005 15:19:00 -0500
Message-ID: <BAY20-DAV136DB975DBB9968F19D458A6810@phx.gbl>


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-l
Received on Thu Jan 20 2005 - 15:25:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US