Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYSTEM tablespace
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
> -------------------------------------
Received on Mon Mar 29 1999 - 14:17:58 CST