Forgot your password?
New user?
Document Actions
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 SYSTEMSolution
Check the size and maxsize of the data files in the SYSTEM tablespaceselect 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>
