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.
Alert.log:
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
Solution:
ALTER DATABASE DATAFILE '/oracle/oraic01/ic_cl_def_128k_01.dbf' RESIZE 1000M
0 comments:
Post a Comment