Re: Unable to extend table

I think you just ran out of space in the system tablespace. you might try to increase the size of the tablespace through the database tools or just sql> alter tablespace system add datafile filespec ...

In article <6p5fkv$edq$1_at_nnrp1.dejanews.com>,   bmolish_at_my-dejanews.com wrote:
>
>
> I am a newbie at Oracle and our main sys admin has left the company.
>
> I just created a brand new oracle database using the NT instance manager, and
> proceeding with running the catalog, catproc, pupbld sql scripts. My
> enviroment is WinNT 4.0 using Oracle Workgroup server 7.34.
>
> The database started sucessfully, and then I proceeded to run an internal
> script that creates tables and then creates rolls and grants rolls. This
> script has worked fine in 7.32 versions of Unix
>
> I keep getting an error which I didn't understand nor can figure out what to
> do.
>
> ORA-00604: error occurred at recursize SQL level 1
> ORA-01653: unable to extend table SYS.OBJAUTH$ by 5 in tablespace SYSTEM.
>
> the line in the script that casues this error is:
> CREATE ROLE SYNCHROROLE;
> grant all on SYNCHRO.synchropublication to synchroRole;
>
> *Note the only tablespace that I currently have setup at this point is SYSTEM.
>
> any help would be greatfull.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 22 1998 - 18:45:51 CDT