Home » RDBMS Server » Server Administration » ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM
ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM [message #53176] Sat, 31 August 2002 22:23 Go to next message
D.Ramakrishnam Raju
Messages: 1
Registered: August 2002
Junior Member
: Here is the error while I'm tryong to create table to test my SQL statements for college.

: SQL> create table stumast(
: 2 stno char(7),
: 3 name varchar2(50),
: 4 primary key(stno)
: 5 );

: create table stumast(
: *
: ERROR at line 1:
: ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM
:

Report message to a moderator

Re: ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM [message #53183 is a reply to message #53176] Sun, 01 September 2002 11:03 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
You are either connected as SYS , user which default tablespace is SYSTEM or you don't have free disk space in SYSTEM tablespace.

Add more disk space to the SYSTEM tablespace datafile(s), or user another user account.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Re: ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM [message #55000 is a reply to message #53176] Mon, 23 December 2002 22:49 Go to previous message
Kumar
Messages: 115
Registered: December 1998
Senior Member
Increase the size of SYSTEM tablespace.

Report message to a moderator

Previous Topic: Help! Oracle Error 27062 - AIO wait timeout
Next Topic: Oracle can't startup
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 20:12:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.