ORA-30036: 无法按 8 扩展段 (在还原表空间 'UNDOTBS02' 中) 错误的解决
今天在学习oracle undo表空间时，在测试表中插入大量数据时出现ORA-30036: 无法按 8 扩展段 (在还原表空间 'UNDOTBS02' 中)
解决办法如下：（参考博客http://blog.sina.com.cn/s/blog_676255e101018d5s.html）
解决办法如下：（参考博客http://blog.sina.com.cn/s/blog_676255e101018d5s.html）
1.查询了一下undo表空间的使用,发现已经超过了80%
2.将undo表空间大小重新加大点,解决问题~
SELECT a.tablespace_name as tablespace_name,
to_char(b.total/1024/1024,999999.99) as Total,
to_char((b.total-a.free)/1024/1024,999999.99) as Used,
to_char(a.free/1024/1024,999999.99) as Free,
to_char(round((total-free)/total,4)*100,999.99) as Used_Rate
FROM (SELECT tablespace_name, sum(bytes) free FROM DBA_FREE_SPACE GROUP BY tablespace_name) a,
(SELECT tablespace_name, sum(bytes) total FROM DBA_DATA_FILES GROUP BY tablespace_name ) b
WHERE a.tablespace_name=b.tablespace_name
AND a.tablespace_name='UNDOTBS1'
ORDER BY a.tablespace_name;
to_char(b.total/1024/1024,999999.99) as Total,
to_char((b.total-a.free)/1024/1024,999999.99) as Used,
to_char(a.free/1024/1024,999999.99) as Free,
to_char(round((total-free)/total,4)*100,999.99) as Used_Rate
FROM (SELECT tablespace_name, sum(bytes) free FROM DBA_FREE_SPACE GROUP BY tablespace_name) a,
(SELECT tablespace_name, sum(bytes) total FROM DBA_DATA_FILES GROUP BY tablespace_name ) b
WHERE a.tablespace_name=b.tablespace_name
AND a.tablespace_name='UNDOTBS1'
ORDER BY a.tablespace_name;
2.将undo表空间大小重新加大点,解决问题~
（1）可直接下载DBATools在PLSQL中进行界面化修改
（2）alter database datafile 'D:\APP\MAXINE\ORADATA\SMART\UNDOTBS02.DBF' resize 100m;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29622945/viewspace-1365920/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle 审计 学习笔记
下一篇：
oracle undo 学习笔记
请登录后发表评论
登录
全部评论
