Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00604 and ORA-01653: unable to extend table

wucisSep 11 2018 — edited Sep 12 2018

Hello,

yesterday I got the following error messages:

ORA-00604: error occurred at recursive SQL level 1

ORA-01653: unable to extend table SYS.OBJ$ by 128 in tablespace SYSTEM

I'm using

Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

and

Application Express 5.1.3.00.05

on  a linux machine. The datafiles look as follows:

drwxr-xr-x 2 oracle dba  4096 Sep  1  2016 ./
drwxr-x--- 3 oracle dba  4096 Okt  2  2015 ../

-rw-r----- 1 oracle dba   10559488 Sep 10 22:37 APEX_2597601439293398.dbf

-rw-r----- 1 oracle dba9781248 Sep 11 07:42 control.dbf

-rw-r----- 1 oracle dba 5630861312 Sep 11 07:40 sysaux.dbf

-rw-r----- 1 oracle dba  629153792 Sep 11 07:40 system.dbf

-rw-r----- 1 oracle dba 4858060800 Sep 11 07:07 temp.dbf

-rw-r----- 1 oracle dba 2013274112 Sep 11 07:41 undotbs1.dbf

-rw-r----- 1 oracle dba 1499471872 Sep 11 07:38 users.dbf

How can I fix this ?

This post has been answered by unknown-3431574 on Sep 11 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2018
Added on Sep 11 2018
14 comments
4,726 views