Monday, September 16, 2013

ORA-01653: unable to extend table in tablespace string tips

ORA-12096: error in materialized view log on ****.****
ORA-01653: unable to extend table  ****.**** by 1024 in tablespace ****

ORA-01653: unable to extend table in tablespace string tips


The Oracle docs note this on the ora-01653 error:

ORA-01653: unable to extend table string.string by string in tablespace string
    Cause: Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated.
    Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
Oracle MOSC Documents offer great resources on resolving ORA-01653,  namely the nature of the problem as it relates to space availability:

    Explanation:
    ------------
    This error does not necessarily indicate whether or not you have enough space
    in the tablespace, it merely indicates that Oracle could not find a large enough area of free
    contiguous space in which to fit the next extent.

SOURCE - http://www.dba-oracle.com/t_ora_01653_unable_to_extend_table_string_string_by_string_in_tablespace_string.htm

No comments:

Post a Comment

web stats