Unanswered: ORA-1653: unable to extend table/cluster
I need help regarding the error i encountered. i already did some adjustments but still encountering the same.
ORA-1653: unable to extend table/cluster SWBAPPS.SW_ATTACHMENT by 384256 in tablespace VANTIVE_DATA
Executed the following:
1. alter database datafile '/van_backup/VANTIVE/van_dat04.dbf' resize 1000M and still the problem occurred (Note: about 629M added)
2. alter tablespace VANTIVE_DATA default storage (maxextents 2000) and still the problem occurred (Note: previously maxextents is 1500)
3. alter table SWBAPPS.SW_ATTACHMENT storage (maxextents 2000) and still problem occurred (Note: previously maxextents is 1500)
================================================== ================================================== ==
Additional information for your reference:
select * from dba_segments where tablespace_name = 'VANTIVE_DATA' and segment_name = 'SW_ATTACHMENT'
select substr(a.tablespace_name,1,40) "Tablespaces",
to_char(a.next_extent,'999,999,999,999') "NEXT Needed",
to_char(b.next_ext,'999,999,999,999') "MAX Available"
from sys.dba_segments a, sys.temprpt_next_vw b
and b.next_ext < a.next_extent;
NEXT needed: 1,573,912,576
MAX Available: 639,016,960