Hi!

I need help regarding the error i encountered. i already did some adjustments but still encountering the same.

Error msg
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'

Output:
Owner: SWBAPPS
Seg_Name: SW_ATTACHMENT
TablespaceName: VANTIVE_DATA
Header_Block: 10449
Bytes: 3282935808
Blocks: 801498
Extents: 37
Initial_Extent: 16384
Next_Extent: 1573912576
Min_Extents: 1
Max_Extents: 2000
PCT_Increase: 0

select substr(a.tablespace_name,1,40) "Tablespaces",
substr(a.segment_name,1,40) "Segment",
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
where a.tablespace_name=b.tablespace_name
and b.next_ext < a.next_extent;

Output:
Tablespaces: VANTIVE_DATA
Segment: SW_ATTACHMENT
NEXT needed: 1,573,912,576
MAX Available: 639,016,960

Thank you very much