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: Problem with table creation (tablespace)

Re: Problem with table creation (tablespace)

From: Thomas Vanya <twvanya_at_nospameastman.com>
Date: 1997/10/23
Message-ID: <01bcdfdf$a3e62000$0cdb74a6@pc88511209.tex.emn.com>#1/1

You have run out of available space in your SYSTEM tablespace. You will likely need to allocate another datafile to this tablespace.

-- 
Thomas W. Vanya
Oracle and OracleRdb Database Administrator
Eastman Chemical Company
-------------------------------------------------------------------------
(Due to proliferation of spammers, remove nospam from address.)

decan_at_expertel.fr wrote in article <877618284.24004_at_dejanews.com>...

> Hi folks,
>
> I'm a completely newbie concerning Oracle DBA and I have to test some
> database access from an application.
> I'm using Oracle 7.3.
>
> I was able once to create a sample table, but now that I have to create
> the 'real' test tables I get the following message :
>
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01655: unable to extend cluster SYS.C_OBJ# by 140 in tablespace
SYSTEM
>
> whenever I try to create a table, even when I try with another user. It's
> just the same with user MANAGER.
>
> I'm completely stuck with this, any help will be appreciated.
>
> Thanks in advance...
>
> Nicolas Hatton
> DECAN RCE Paris
>
> PS: please answer by EMail as I don't have direct access to a NNTP server
> excepting DejaNews. Thanks.
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
Received on Thu Oct 23 1997 - 00:00:00 CDT

Original text of this message

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