ORA-01655: unable to extend cluster SYS.C_OBJ# by 128 in tablespace SYSTEM

Your system tablespace is full

 

- > tablespace 용량확인

 

SELECT A.TABLESPACE_NAME "TABLESPACE Name",

      ROUND(MAXBYTES/1048576,2) "최대용량(MB)",

      ROUND(A.BYTES_ALLOC / 1024 / 1024, 2) "할당용량(MB)",

      ROUND(NVL(B.BYTES_FREE, 0) / 1024 / 1024, 2) "여유용량(MB)",

      ROUND((A.BYTES_ALLOC - NVL(B.BYTES_FREE, 0)) / 1024 / 1024, 2) "사용량(MB)",

      ROUND((NVL(B.BYTES_FREE, 0) / A.BYTES_ALLOC) * 100,2) "여유%",

      100 - ROUND((NVL(B.BYTES_FREE, 0) / A.BYTES_ALLOC) * 100,2) "사용%"

FROM  ( SELECT F.TABLESPACE_NAME,

                SUM(F.BYTES) BYTES_ALLOC,

                SUM(DECODE(F.AUTOEXTENSIBLE, 'YES',F.MAXBYTES,'NO', F.BYTES)) MAXBYTES

        FROM DBA_DATA_FILES F

        GROUP BY TABLESPACE_NAME) A,

      ( SELECT F.TABLESPACE_NAME,

                SUM(F.BYTES)  BYTES_FREE

        FROM DBA_FREE_SPACE F

        GROUP BY TABLESPACE_NAME) B

WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME (+)

      UNION

      SELECT TABLESPACE_NAME,

            ROUND(SUM(BYTES_USED + BYTES_FREE) / 1048576, 2),

            ROUND(SUM(BYTES_FREE) / 1048576,2),

            ROUND(SUM(BYTES_USED) / 1048576,2),

            ROUND((SUM(BYTES_FREE) / SUM(BYTES_USED + BYTES_FREE)) * 100,2) FREE_RATE,

            100 - ROUND((SUM(BYTES_FREE) / SUM(BYTES_USED + BYTES_FREE)) * 100,2) USED_RATE,

            ROUND(MAX(BYTES_USED + BYTES_FREE) / 1048576, 2)

      FROM  SYS.V_$TEMP_SPACE_HEADER

GROUP BY TABLESPACE_NAME

ORDER BY 1;

 

해결 : tablespace 늘리기