错误信息:
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的容量增大即可。