Re: SYSTEM tablespace

In article <36FFDAA5.87C4FADC_at_tumbleweed.com>,   David Dodini <david_at_tumbleweed.com> 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
> -------------------------------------
>

Hi, The error message informs u that it is not able allocate initial extent for the table u wanted to create. The reason may be 1.The tablespace is not having a single extent of this size but may be having small non contigious extents. 2.The tablespace is not having sufficient space.

the solution is
increase the tablespace size which can be done by

1.adding one more datafile to the tablespace or
2.resize the datafile to a high value.
3.say autoextend ON for system datafile.

or if u r sure that u'r tablespace is granmented(i.e have small non contigious chunks) export all the tables in that tablespace drop all tables and import the tables.

hope this helps

kvsraju
Oracle DBA
Polaris software lab ltd,
MADRAS
INDIA
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 05 1999 - 04:39:58 CDT