Tuesday, March 15, 2016

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

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.

Solution:

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

No comments:

Post a Comment