Re: Locally Managed Tablespaces

  • From: Ken Payton <ken.payton@xxxxxxxxxxxxxxxxxx>
  • To: rlsmith@xxxxxxx
  • Date: Thu, 20 Jan 2005 15:10:24 -0500

The create parameters are not ignored.  If the create table has a
initial extent of 100MB and the locally managed tablespace size is 1MB,
it will be created with an initial 100 extents.


On Thu, 2005-01-20 at 14:47, Smith, Ron L. wrote:
> 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.
> --
> //
Kenny Payton
Software Architect
Public Records Group, Boca Raton
Choicepoint, Inc.
o: (770)752-4054
c: (561)926-4119

Other related posts: