Oracle DBA, How To, Error, Cause and Action

ORA-01683: unable to extend index string.string partition string bystring in tablespace string

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




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




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