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

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

Locally Managed Tablespaces

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Thu, 20 Jan 2005 13:47:51 -0600
Message-ID: <270A0BDDFDE54E41B78F0F06D82A66B80134630A@okcexg3.kmg.com>


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

Hope this is clear.=20

Thanks!=20
Ron=20

Important Notice!!
If you are not the intended recipient of this e-mail message, any use, = distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received = this message by mistake, then delete the e-mail message. Thank you.

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

Original text of this message

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