Re: Change SYSTEM's default tablespace?

From: Dave A <dave_and_vanna_at_hotmail.com>
Date: Tue, 26 Sep 2000 20:25:45 -0500
Message-ID: <st2ipei2phd63e@corp.supernews.com>

Did the previous DBA leave under less than desirable circumstances? It would seem so.

Set SYSTEM's default tablespace to SYSTEM and minextents=1

--
Dave A


<kb> wrote in message news:39d12f90.84099247_at_news.mindspring.com...


> I've been looking over some database creation scripts left by the

> previous DBA at my company and found the following:

> Early on in the db creation, the SYSTEM user is altered to set the

> default tablespace to USER1, which is obviously not an

> Oracle-generated tablespace.  One of the attributes of this tablespace

> is minextents = 50 with extent size = 32k.  When I use these scripts

> to create a database, I end up with huge amounts of apparently unused

> storage allocated to SYSTEM's tables in this tablespace.  What would

> be the benefit of doing this?

> From my modest experience and knowledge I'm tempted to believe that

> perhaps the SYSTEM id should be left alone.

> Does anyone have any helpful thoughts on the topic?

> Thank you,

> Kenneth Buck

>

>

Received on Tue Sep 26 2000 - 20:25:45 CDT