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-01654: unable to extend index user.index_x by 16 in tablespace tablespa

Cherif bhSep 8 2011 — edited Sep 14 2011

Hi all,

I get the error message : ORA-01654: unable to extend index user.index_x by 16 in tablespace tablespace_t after an insert into table table_x(having the index index_x ).

Could you please help me ? Should I add new datafile? Is there any other solution

I have get this message before, I have added new datafile to this tablespace,

ALTER TABLESPACE tablespace_t ADD DATAFILE 'C:\APP\...\ORADATA\MABASE\S_TAB_user02.DBF' SIZE 500M
AUTOEXTEND ON NEXT 100M MAX SIZE 1000M;

TABLESPACE_NAME ALLOUE OCCUPE LIBRE
1 tablespace_t 5720 5421 297

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2011

Added on Sep 8 2011

#general-database-discussions, #oracle

4 comments

1,385 views