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
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 -
No comments:
Post a Comment