RE: Locally Managed Tablespaces

  • From: "Subbiah, Nagarajan" <Nagarajan.Subbiah@xxxxxxxx>
  • To: "'rlsmith@xxxxxxx'" <rlsmith@xxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 20 Jan 2005 15:12:25 -0500

Is the Uniform allocation has any advantageous than SYSTEM allocation type?
Does the SYSTEM allocation type has any issues?


-----Original Message-----
From: Smith, Ron L. [mailto:rlsmith@xxxxxxx] 
Sent: Thursday, January 20, 2005 2:48 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Locally Managed Tablespaces

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

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


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.

Other related posts: