Thursday, June 14, 2012
12:51 PM

ORA-01653: unable to extend table string.string by string in tablespace string


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.


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

:) :)) ;(( :-) =)) ;( ;-( :d :-d @-) :p :o :>) (o) [-( :-? (p) :-s (m) 8-) :-t :-b b-( :-# =p~ $-) (b) (f) x-) (k) (h) (c) cheer
Click to see the code!
To insert emoticon you must added at least one space before the code.