Skip to Main Content
Forums

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-1683 unable to extend index - And Too much Index size.

Ozgur Umut VurgunNov 30 2011 — edited Dec 1 2011
Hello,

I've taken " ORA-1683: unable to extend index TS001.TEMP_PK partition P20110925 by 64 in tablespace TS001_TEMP_I_ " in alert.log. You can find system info on below ;
Index size =140 GB (It is too big, I am open to any suggestions for decrease size. )
Table size = 600 GB
OS disk percent is 85% usage .

So, Our performance very slowly. How can I fix our problems ?


Thanks...
This post has been answered by CKPT on Nov 30 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2011
Added on Nov 30 2011
#general-database-discussions, #index, #to
9 comments
3,721 views