에러내용 :
java.sql.SQLException: ORA-01653: unable to extend table ynkim.tblaename by 128 in tablespace SYSTEM
테이블스페이스별 공간 잔여량 확인 :
SELECT A.TABLESPACE_NAME AS "테이블스페이스명"
, A.BYTES / 1024 AS "전체(MB)"
, (A.BYTES - NVL(B.FREEBYTES,0)) / 1024 AS "사용량(MB)"
, NVL(B.FREEBYTES,0) / 1024 AS "잔여량(MB)"
, ROUND(NVL(B.FREEBYTES,0)*100/A.BYTES,2) AS "%"
FROM (
SELECT TABLESPACE_NAME
, SUM(BYTES) BYTES
FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME
) A
, (
SELECT TABLESPACE_NAME
, SUM(NVL(BYTES,0)) FREEBYTES
FROM DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME
) B
WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME(+)
ORDER BY 5 ASC ;
해결 : default system 테이블 스페이스공간 부족으로 확인.
alter database datafile 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF' resize 1024M
댓글