ORA-01691: unable to extend LOB segment name.name by num in tablespace name Cause: An extent could not be allocated for a LOB segment in the specified tablespace. Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the specified tablespace. 是要插入的表无法申请到下一个扩展,检查该表所在的表空间是否不足了。
有没有什么办法让他先取出来,再插入表b中,因为b中的有个字段seq是要累加的,insert into a (col_lob) select dbms_lob.substr(col_lob) from b 肯定没有办法让他累加吧
累加可以用分析函数实现insert into a (col_lob) select sum(dbms_lob.substr(col_lob)) over(order by rownum) from b
Cause: An extent could not be allocated for a LOB segment in the specified tablespace. Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the specified tablespace.
是要插入的表无法申请到下一个扩展,检查该表所在的表空间是否不足了。
肯定没有办法让他累加吧