Sign in Subscribe
Oracle

ORA-01654: unable to extend index

Mark Allen

Database can't extent an index.

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

SolutionCheck 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>