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

Home -> Community -> Usenet -> c.d.o.server -> Re: SYSTEM tablespace

Re: SYSTEM tablespace

From: David Dodini <david_at_tumbleweed.com>
Date: Mon, 29 Mar 1999 14:06:50 -0800
Message-ID: <36FFF97A.6B1D9D08@tumbleweed.com>


Marc,

Thanks for the reply. The installation requires and creates a database user. It is not installed as the SYSTEM oracle user. Thank you for the information.

Sincerely,
David Dodini

Marc Mazerolle wrote:

> Questions :
>
> Does your installation require a specific oracle user or does it require the
> "SYSTEM" oracle user ? If it requires the SYSTEM user, I would think twice
> about installing it. If it requires a specific user, modify this users
> default tablespace which must by "SYSTEM" by using the following command :
>
> ALTER USER ... DEFAULT TABLESPACE TSD_DATA;
>
> By default, the default tablespace of a user is SYSTEM which would cause
> installation of objects in the SYSTEM tablespace which is not meant to hold
> application specific objects for many reasons i will not explain here.
>
> Regards,
>
> Marc Mazerolle
> InforMaze Technologies
>
> David Dodini wrote:
>
> > Hello,
> >
> > I was doing an installation of a product that creates a schema in an
> > Oracle database this morning. The following error was returned to me
> > during this part of the installation:
> >
> > *******
> > ERROR at line 1:
> > ORA-01658: unable to create INITIAL extent for segment in tablespace
> > SYSTEM
> > *******
> >
> > I dropped the user and all of its database objects that the installation
> > script creates. On subsequent installations I still received the
> > aforementioned error message. Not being an Oracle dba the best I can
> > gather is that there is some sort of fragmentation of the system
> > tablespace. Is this correct? More importantly, how do I reset my system
> > tablespace so that I can do installations and not run into this problem?
> > Any help would be greatly appreciated.
> >
> > Sincerely,
> > David Dodini
> >
> > --
> > -------------------------------------
> > David Dodini
> > Senior Quality Assurance Engineer
> > Tumbleweed Software Corp.
> > 1-650-569-3679
> > david_at_tumbleweed.com
> > -------------------------------------

--



David Dodini
Senior Quality Assurance Engineer
Tumbleweed Software Corp.
1-650-569-3679
david_at_tumbleweed.com
Received on Mon Mar 29 1999 - 16:06:50 CST

Original text of this message

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