ORA-01691: unable to extend lob segment SYSADM.SYS_LOB0000159872C00007$$ by 128 in tablespace PSIMAG

錯誤資訊：

File: /vob/peopletools/src/pspcm/pcmeweb.cppSQL error. Stmt #: 11681  Error Position: 0  Return: 1691 - ORA-01691: unable to extend lob segment SYSADM.SYS_LOB0000159872C00007$$ by 128 in tablespace PSIMAGE2

Failed SQL stmt: INSERT INTO PSFILE_ATTDET (ATTACHSYSFILENAME, FILE_SEQ, VERSION, FILE_SIZE, LASTUPDDTTM,    LASTUPDOPRID, FILE_DATA) VALUES (:1,:2,:3,:4,TO_TIMESTAMP(:5,'YYYY-MM-DD-HH24.MI.SS.FF'),:6,:7) 

解決辦法：

  用sys/manager登陸PLSQL後，查詢：

SELECT a.tablespace_name "tbs name", b.NAME "file path"

  FROM dba_tablespaces a, v$datafile b, v$tablespace c

WHERE a.tablespace_name = c.NAME

   AND c.ts# = b.ts#;

找到表空間HRLARGE對應存儲DATA FILE的路徑：

然後執行SQL：

  alter database datafile '/db/app/oracle/oradata/HR92PRD/hrlarge.dbf' autoextend on next 100m maxsize 4000M;

把HRLARGE存儲DATA FILE的容量增大即可。