Re: Unable to extend table

You're effectively "out of space" in your system tablespace. The Data Dictionary tables can't extend (grow). You'll need to increase the size of your system tablespace. You can use OEM or you can extend manually. You can also set autoextend on, which will solve your problem. If you're not familiar with how to do this, you should check you documentation or shoot me an email directly and I'll try to give you a hand.

Steve Miller
Database Administrator
Oracle Certified Professional - DBA
smiller_at_gers.com
http://www.gers.com

bmolish_at_my-dejanews.com wrote in article <6p5fkv$edq$1_at_nnrp1.dejanews.com>...
>
>
>
> 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
>
Received on Wed Jul 22 1998 - 16:58:07 CDT