ORA-01653: unable to extend table by 64 in tablespace APPS_TS_TX_DATA

Unable to extend tablespace error occurs when the tablespace where the data is being loaded is running out of allocated space.
Ex: Table X is created in APPS_TS_TX_DATA with an allocated space of 10GB which might have man other tables.

When a program is trying to load data when the tablespace is full we encounter this error.

Below are couple of queries which I use. (Pls Note :These are from Ask Tom) I am sharing here to help others.

-----Tablespace stats-----
select (select decode(extent_management,'LOCAL','*',' ') ||
decode(segment_space_management,'AUTO','a ','m ')
from dba_tablespaces where tablespace_name = b.tablespace_name) ||
nvl(b.tablespace_name,
nvl(a.tablespace_name,'UNKOWN')) name,
kbytes_alloc/1024/1024 kbytes,
(kbytes_alloc-nvl(kbytes_free,0))/1024/1024 used,
nvl(kbytes_free/1024/1024,0) free,
((kbytes_alloc-nvl(kbytes_free,0))/ kbytes_alloc)*100 pct_used,
nvl(largest,0) largest,
nvl(kbytes_max,kbytes_alloc) Max_Size,
decode( kbytes_max, 0, 0, (kbytes_alloc/kbytes_max)*100) pct_max_used
from ( select sum(bytes)/1024 Kbytes_free,
max(bytes)/1024 largest,
tablespace_name
from sys.dba_free_space
group by tablespace_name ) a,
( select sum(bytes)/1024 Kbytes_alloc,
sum(maxbytes)/1024 Kbytes_max,
tablespace_name
from sys.dba_data_files
group by tablespace_name
union all
select sum(bytes)/1024 Kbytes_alloc,
sum(maxbytes)/1024 Kbytes_max,
tablespace_name
from sys.dba_temp_files
group by tablespace_name )b
where a.tablespace_name (+) = b.tablespace_name
and a.tablespace_name like '%APPS%DATA%'
order by 1

---Table Sizes------
select segment_name,sum((BYTES)/(1024*1024*1024)) "Allocated(GB)"
from dba_extents
where segment_name like 'XX_%' or segment_name like 'XXCOM_TEST'
group by segment_name
order by 2 desc;