ORA-01652: unable to extend
Thanks in advance
Tablespace is having almost 2.9G free space.
select initial_extent,next_extent from dba_tablespaces where tablespace_name='PRONTOMSP';
INITIAL_EXTENT NEXT_EXTENT
-------------- -----------
10485760 10485760
i dont know why it is giving error. Any clues in this. ?
ORA-01652: unable to extend temp segment by 61446 in tablespace PRONTOMSP
ORA-1653: unable to extend table
thanks in advance
ORA-1653: unable to extend table QADB0703.PRONTO_ALERT by 466608 in tablespace OSSBSS
i AM GETTING THIS ERROR
details
free space in this tablespace is 16gb.
SQL> select INITIAL_EXTENT,NEXT_EXTENT,MIN_EXTENTS,MAX_EXTENTS from dba_Segments where SEGMENT_NAME='PRONTO_ALERT';
INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
-------------- ----------- ----------- -----------
20480 20480 1 249
20480 1911226368 1 249
select INITIAL_EXTENT,NEXT_EXTENT,MIN_EXTENTS,MAX_EXTENTS from dba_Segments where TABLESPACE_NAME='OSSBSS';
INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
-------------- ----------- ----------- -----------
20480 20480 1 249
20480 20480 1 249
20480 20480 1 249
20480 20480 1 249
20480 20480 1 249
WHAT SHOULD I DO?
shall i increase the initial & next to 10m each