Re: Unable to extend table

You can check the Oracle Error Message Manual to get the resolution of the problem against your error.

In this case for error ORA-01653 this is what Error Manual says:--

===============================Start=========================

ORA-01653 unable to extend table name.name by num in tablespace name

Cause: Failed to allocate extent for table segment in tablespace.

Action: Use the ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the specified tablespace.

===============================End=========================

It is clear from the above message that you need to add a datafile to the tablespace alternatively if your Oracle version allows to extend the data file you can extend it to create more space.

Hope this helps,

I just want to convey that sometimes it is good to check error manual for problem resolution.

Manoj Jain
Certified Oracle Professional - DBA
Chauncey Certified Oracle7 - DBA

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 - 21:20:12 CDT