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!

Newbie: ORA-1654,ORA-1688,ORA-1653 "unable to extend index/table"

user94886Nov 9 2007 — edited Nov 9 2007
Hi!

I have gotten a lot of these three ORA-erros in my alertlog:

ORA-1654: unable to extend index SYS.SYS_IOT_TOP_8835 by 128 in tablespace SYSAUX

ORA-1653: unable to extend table SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY by 128 in tablespace SYSAUX

ORA-1688: unable to extend table SYS.WRH$_LATCH partition WRH$_LATCH_1494888728_1416 by 128 in tablespace SYSAUX

Info about SYSAUX:

Allocation Type Automatic
Segment Space Management Automatic
Enable logging Yes
Block Size (B) 8192

Datafile:

Name +ORA_1/db07/sysaux.dbf
Tablespace SYSAUX
Status Online
File Size (KB) 1239040
Auto Extend Yes
Increment 10240KB
Maximum File Size 1500MB

So, how do I solve this? And please, Im quite new to this, so be nice :-)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2007
Added on Nov 9 2007
4 comments
1,586 views