Unable to extend table

From: <bmolish_at_my-dejanews.com>
Date: Wed, 22 Jul 1998 19:47:42 GMT
Message-ID: <6p5fkv$edq$1@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 - 14:47:42 CDT