Oracle DBA, How To, Error, Cause and Action

ORA-01654: unable to extend index string.string by string in tablespacestring

ORA-01654: unable to extend index string.string by string in tablespace string




Cause: Failed to allocate an extent of the required number of blocks for an index segment in the tablespace indicated.




Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.