Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYSTEM tablespace
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
> > -------------------------------------
--