ORA 1688 에러발생

1.ORA 1688 에러발생.
[ORA-01688: unable to extend table BILL.TB_BERR partition P200608]

oerr ora 1688
01688, 00000, "unable to extend table %s.%s partition %s by %s in tablespace %s"
// *Cause: Failed to allocate an extent for table segment in tablespace.
// *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
// files to the tablespace indicated.

2.해당 테이블 스페이스 사용현황 조회.
SELECT a.tablespace_name,
a.total as "Total(Mb)",
a.total - b.free as "Used(Mb)",
nvl(b.free,0) as "Free(Mb)",
round((a.total - nvl(b.free,0))*100/total,0) as "Used(%)"
FROM (select tablespace_name,
round((sum(bytes)/1024/1024),0) as total
from dba_data_files
group by tablespace_name) a,
(select tablespace_name,
round((sum(bytes)/1024/1024),0) as free
from dba_free_space
group by tablespace_name) b
WHERE a.tablespace_name = b.tablespace_name(+)
AND a.tablespace_name like 'M_ETC1_P%'
ORDER BY a.tablespace_name, 4;

3.해당 tablespace의 data file 추가 또는 늘려주기.
alter database datafile ‘users01’ resize 10m;
또는
alter tablespace add datafile ‘users02’ to TBLSPACE;