ORA-01691: Lob 段 SYSTEM.SYS_LOB0000126575C00007$$ 无法通过 8192 (在表空间 SYSTEM 中) 扩展

最新推荐文章于 2023-01-31 16:47:23 发布

LI_AINY

最新推荐文章于 2023-01-31 16:47:23 发布

阅读量4.2k

点赞数

分类专栏： --------数据库---- # ORACLE

本文链接：https://blog.csdn.net/LI_AINY/article/details/93897456

版权

--------数据库---- 同时被 2 个专栏收录

21 篇文章 0 订阅

订阅专栏

ORACLE

9 篇文章 0 订阅

订阅专栏

修改表的时候出现的异常，原因是表空间不足了。报错详情见标题4
解决办法：
a.查询所有表空间大小以及文件位置

select tablespace_name, file_id, file_name,

round(bytes/(1024*1024),0) total_space

from dba_data_files

order by tablespace_name;

b.得到SYSTEM（就是你的不足的表空间的名字）的文件位置以及大小
在这里插入图片描述
3. 接下来两种办法
第一种：将原有表空间扩大

alter database datafile 'D:\APP\JIUQI\ORADATA\ORCL\SYSTEM01.DBF' resize 4000m;

第二种：给SYSTEM新建一个表空间

alter tablespace SYSTEM
     add datafile 'D:\APP\JIUQI\ORADATA\ORCL\SYSTEM02.DBF' size 32700m

错误详情

java.lang.RuntimeException: 发布逻辑表'REV_TOMATERIAL_APPLY'时，元数据操作发生异常。
	at com.jiuqi.dna.core.impl.SystemService.isolatePublishMetadataModify(SystemService.java:864)
	at com.jiuqi.dna.core.impl.SystemService.publishTableDefine(SystemService.java:627)
	at com.jiuqi.dna.core.impl.SystemService.access$3(SystemService.java:613)
	at com.jiuqi.dna.core.impl.SystemService$PublishTableDefine.handle(SystemService.java:584)
	at com.jiuqi.dna.core.impl.SystemService$PublishTableDefine.handle(SystemService.java:1)
	at com.jiuqi.dna.core.impl.ServiceBase$TaskMethodHandler.handle(ServiceBase.java:1)
	at com.jiuqi.dna.core.impl.ContextImpl.serviceHandleTask(ContextImpl.java:349)
	at com.jiuqi.dna.core.impl.ContextImpl.handle(ContextImpl.java:389)
	at com.jiuqi.dna.core.impl.ContextImpl.handle(ContextImpl.java:406)
	at com.jiuqi.dna.bap.datastructure.service.MainbodyService$PostMainbodyHandler.handle(MainbodyService.java:1402)
	at com.jiuqi.dna.bap.datastructure.service.MainbodyService$PostMainbodyHandler.handle(MainbodyService.java:1)
	at com.jiuqi.dna.core.resource.ResourceService$TaskMethodHandler.handle(ResourceService.java:1)
	at com.jiuqi.dna.core.impl.ServiceBase$TaskMethodHandler.handle(ServiceBase.java:1)
	at com.jiuqi.dna.core.impl.ContextImpl.serviceHandleTask(ContextImpl.java:349)
	at com.jiuqi.dna.core.impl.ContextImpl.handle(ContextImpl.java:389)
	at com.jiuqi.dna.core.impl.SituationImpl.handle(SituationImpl.java:1482)
	at com.jiuqi.dna.bap.datastructure.ui.page.MainPage$24$1.widgetSelected(MainPage.java:1743)
	at com.jiuqi.dna.ui.wt.widgets.Dialog.fireWigetSelected(Dialog.java:171)
	at com.jiuqi.dna.ui.wt.widgets.Dialog$ActionListenerImpl.actionPerformed(Dialog.java:183)
	at com.jiuqi.dna.ui.wt.internal.elements.EventUtil$3.run(EventUtil.java:76)
	at com.jiuqi.dna.ui.wt.internal.elements.WidgetElement.fireEvent(WidgetElement.java:563)
	at com.jiuqi.dna.ui.wt.internal.elements.EventUtil.fireActionPerformed(EventUtil.java:73)
	at com.jiuqi.dna.ui.wt.internal.elements.ButtonElement.fireActionPerformed(ButtonElement.java:32)
	at com.jiuqi.dna.ui.wt.internal.elements.ButtonElement.processAction(ButtonElement.java:27)
	at com.jiuqi.dna.ui.engine.adapter.AbstractIOAdapter.processClientAction(AbstractIOAdapter.java:23)
	at com.jiuqi.dna.ui.engine.services.SynchronizeUtil.processAction(SynchronizeUtil.java:218)
	at com.jiuqi.dna.ui.engine.services.SynchronizeUtil.processUpdateMessage(SynchronizeUtil.java:103)
	at com.jiuqi.dna.ui.engine.services.SynchronizeUIService.handle(SynchronizeUIService.java:117)
	at com.jiuqi.dna.ui.engine.UIService.handle(UIService.java:13)
	at com.jiuqi.dna.ui.launch.internal.channels.ChannelServerUtil.handleService(ChannelServerUtil.java:169)
	at com.jiuqi.dna.ui.launch.internal.channels.http.HttpChannelServer$1.runWidthContext(HttpChannelServer.java:209)
	at com.jiuqi.dna.ui.launch.internal.channels.ChannelServerUtil.execContextRunnable(ChannelServerUtil.java:50)
	at com.jiuqi.dna.ui.launch.internal.channels.http.HttpChannelServer.doService(HttpChannelServer.java:178)
	at com.jiuqi.dna.ui.launch.internal.channels.http.HttpChannelServer.doPost(HttpChannelServer.java:58)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1496)
	at com.jiuqi.dna.core.impl.ServletValidateFilter.doFilter(ServletValidateFilter.java:58)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501)
	at com.jiuqi.dna.core.jetty.JettyServer$3.doHandle(JettyServer.java:444)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:229)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:429)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
	at org.eclipse.jetty.server.Server.handle(Server.java:366)
	at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494)
	at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:982)
	at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1043)
	at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865)
	at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
	at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:696)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:53)
	at com.jiuqi.dna.core.jetty.HttpWorkForJetty.doWork(HttpWorkForJetty.java:21)
	at com.jiuqi.dna.core.spi.work.WorkingThread.run(WorkingThread.java:44)
Caused by: com.jiuqi.dna.core.da.SQLExecutionException: ORA-01691: Lob 段 SYSTEM.SYS_LOB0000126575C00007$$ 无法通过 8192 (在表空间 SYSTEM 中) 扩展
ORA-06512: 在 "SYSTEM.DNA_CORE_METADATA_HIST_WRITTER", line 1
ORA-04088: 触发器 'SYSTEM.DNA_CORE_METADATA_HIST_WRITTER' 执行过程中出错

	at com.jiuqi.dna.core.internal.db.metadata.DbMetadata.raise(DbMetadata.java:154)
	at com.jiuqi.dna.core.internal.db.support.oracle.OracleMetadata.raise(OracleMetadata.java:358)
	at com.jiuqi.dna.core.internal.db.datasource.StatementWrap.raise(StatementWrap.java:133)
	at com.jiuqi.dna.core.internal.db.datasource.PreparedStatementWrap.executeUpdate(PreparedStatementWrap.java:115)
	at com.jiuqi.dna.core.internal.da.sql.execute.SimpleSqlModifier.update(SimpleSqlModifier.java:23)
	at com.jiuqi.dna.core.impl.MoCommand.executeUpdate(MoCommand.java:13)
	at com.jiuqi.dna.core.impl.DBCommandProxy.executeUpdate(DBCommandProxy.java:102)
	at com.jiuqi.dna.core.impl.DBAdapterImpl.executeUpdate(DBAdapterImpl.java:55)
	at com.jiuqi.dna.core.impl.ContextImpl.executeUpdate(ContextImpl.java:3118)
	at com.jiuqi.dna.core.impl.CoreMetadataUtl.save(CoreMetadataUtl.java:38)
	at com.jiuqi.dna.core.impl.SystemService$PublishIsolateMetadataModify.handle(SystemService.java:968)
	at com.jiuqi.dna.core.impl.SystemService$PublishIsolateMetadataModify.handle(SystemService.java:1)
	at com.jiuqi.dna.core.impl.ServiceBase$TaskMethodHandler.handle(ServiceBase.java:1)
	at com.jiuqi.dna.core.impl.ContextImpl.serviceHandleTask(ContextImpl.java:349)
	at com.jiuqi.dna.core.impl.AsyncTaskImpl.workDoing(AsyncTaskImpl.java:146)
	at com.jiuqi.dna.core.spi.work.Work.doWork(Work.java:345)
	... 1 more
Caused by: java.sql.SQLException: ORA-01691: Lob 段 SYSTEM.SYS_LOB0000126575C00007$$ 无法通过 8192 (在表空间 SYSTEM 中) 扩展
ORA-06512: 在 "SYSTEM.DNA_CORE_METADATA_HIST_WRITTER", line 1
ORA-04088: 触发器 'SYSTEM.DNA_CORE_METADATA_HIST_WRITTER' 执行过程中出错

	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
	at com.jiuqi.dna.core.internal.db.datasource.PreparedStatementWrap.executeUpdate(PreparedStatementWrap.java:112)
	... 13 more

LI_AINY

关注

0
点赞
踩
8

收藏

觉得还不错? 一键收藏
0
评论
ORA-01691: Lob 段 SYSTEM.SYS_LOB0000126575C00007$$ 无法通过 8192 (在表空间 SYSTEM 中) 扩展

修改表的时候出现的异常，原因是表空间不足了。报错详情见标题5解决办法：a.查询所有表空间大小以及文件位置select tablespace_name, file_id, file_name,round(bytes/(1024*1024),0) total_spacefrom dba_data_filesorder by tablespace_name;b.得到SYSTEM...
复制链接

扫一扫