Sunday, October 16, 2016

Oracle - Unable to extend index SYS.I_OBJ1 by 8 in tablespace SYSTEM

If you see the following similar error message

unable to extend index SYS.I_OBJ1 by 8 in tablespace SYSTEM

It means that your tablespace is out of space and you should increase it if possible.

You can issue the following command to check your current size of the tablespace

select * from dba_data_files where tablespace_name='SYSTEM';

It will return the path and the current size of the tablespace



The above should that I have only about 650M tablespace.

Then, depend on your current size, you could issue the following 

alter database datafile '/u01/app/oracle/oradata/XE/system.dbf' resize 1024M

Note: The above example is increasing to 1024M to my path. You should modify the path and size according to your need.

Reference:

1. http://www.markcallen.com/oracle/ora-01654-unable-to-extend-index/

No comments:

Post a Comment

Windows 7 - STOP 0x0000007B (0xFFFFF880009A97E8 0xFFFFFFFFC0000034 0x0000000000 0x0000000000)

If you encounter STOP 0x0000007B (0xFFFFF880009A97E8 0xFFFFFFFFC0000034 0x0000000000 0x0000000000) blue screen of death. This is very like...