Share |

ORA-01654: Unable to extend index %s.%s by %s in tablespace %s

The tablespace the index is residing in is unable to extend.

There is not enough space left either due to the datafiles being full, autoextend which is not set at datafile level or due to a disk which's full.

You'll have to check the size of the datafiles attached to the tablespace and check whether they can autoextend or not.
select file_name, bytes, autoextensible, maxbytes
from dba_data_files
where tablespace_name='TABLESPACE_NAME'
Either add more datafiles to the tablespace, set the autoextensible flag or enlarge the datafile(s).

To add more space to a file issue following command:
alter database datafile 'C:\ORACLE\ORADATA\IDX01.DBF' resize 1000m;
To turn on the autoextend feature on a datafile use following command:
alter database datafile 'C:\ORACLE\ORADATA\IDX01.DBF' autoextend on next 100m maxsize 2000m;
To add a new datafile to the tablespace use following command:
alter tablespace IDX add datafile 'C:\ORACLE\ORADATA\IDX02.DBF' size 100m autoextend on next 100m maxsize 2000m;
 Was this information helpful?  Yes No
If it was not helpful, please take some time to explain why. This is not to ask questions, you can do so in the forum.

Welcome to our forum for Oracle error: ORA-01654 Add your own message



 

Actualizando un tabls me retorna este error ORA-01654 UNABLE TO EXTEND INDEX BY IN TABLESPACE
Is this a partitioned table you are getting the problem with?
 
I faced this problem when I tried to create a stored procedure in our remote database server.

Thak you very much for your solution.

Regards and hugs

Nilesh Mehta.
 

Add your message

 Please provide your personal info 



 Please ask your message as briefly and clear as possible 

 Spam Protection 
Validation Code: 7w6hm26y3wivf5e6x


Ask Your Question

If you need more information about this particular error message, you can leave a forum message.

We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.

Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.


Spam Protection

In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.

If you do not enter the validation correctly, your message will not be recorded.


Forum Rules

Please be polite, do not USE ALL UPPERCASE, no insults, violance or any other threats.