ORA-01654: unable to extend index

Database can’t extent an index.

Problem

ORA-01654: unable to extend index SYS.I_FILE#_BLOCK# by 128 in tablespace SYSTEM

Solution

Check the size and maxsize of the data files in the SYSTEM tablespace

select file_name, bytes, autoextensible, maxbytes
from dba_data_files
where tablespace_name=’SYSTEM’;

Increase the size of the data file;

alter database datafile ‘<Path to data file>’ resize <larger size>

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>