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

来源：互联网发布：java面试宝典软件编辑：程序博客网时间：2024/06/03 12:37

错误信息：

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的容量增大即可。

0 0