在pl/sql developer 中执行如下sql语句:SELECT distinct tbl_NodeStatus.ActualhandleUserIDArray,tbl_NodeStatus.Enddate,tbl_Project.djlx,Tbl_Project.DWDM,Tbl_Project.QXDM,tbl_Project.ProjectID,tbl_Project.ProjectTypeID,tbl_Project.ProjectName,to_char(tbl_Project.ProjectBeginTime,'yyyy-mm-dd') ProjectBeginTime,
tbl_Project.IsHalted,tbl_Project.IsSupervised,
tbl_Project.ProjectRestrictTime,
tbl_UserRole.UserID,-1 as AuthorizerID,-1 as ConsignerID,d_Exoticrecord.Zdbh
FROM tbl_UserRole INNER JOIN
tbl_RolePowers ON tbl_UserRole.RoleID = tbl_RolePowers.RoleID AND
tbl_UserRole.ProjectTypeID = tbl_RolePowers.ProjectTypeID AND
tbl_UserRole.VersionID = tbl_RolePowers.VersionID INNER JOIN
tbl_Powers ON
tbl_RolePowers.ProjectTypeID = tbl_Powers.ProjectTypeID AND
tbl_RolePowers.VersionID = tbl_Powers.VersionID AND
tbl_RolePowers.PowersID = tbl_Powers.PowersID INNER JOIN
tbl_Project ON tbl_Powers.VersionID = tbl_Project.VersionID AND
tbl_Powers.ProjectTypeID = tbl_Project.ProjectTypeID INNER JOIN
tbl_NodeStatus ON tbl_Project.ProjectID = tbl_NodeStatus.ProjectID AND
tbl_Powers.NodeID = tbl_NodeStatus.NodeID INNER JOIN
d_Exoticrecord ON tbl_Project.ProjectID = d_Exoticrecord.ProjectID
WHERE (tbl_Project.Ispigeonholed=0) and
(tbl_NodeStatus.NodeState = 2)时出现错误提示框:ORA-01652:无法通过128(在表空间TEMP中)扩展temp段。
ORA-27059:skgfrsz 无法减少文件大小
OSD-04005:SetFilePointer()失败,无法读取文件
O/S-ERROR:(OS 112)磁盘空间不足
不知如何解决,敬请指点!
tbl_Project.IsHalted,tbl_Project.IsSupervised,
tbl_Project.ProjectRestrictTime,
tbl_UserRole.UserID,-1 as AuthorizerID,-1 as ConsignerID,d_Exoticrecord.Zdbh
FROM tbl_UserRole INNER JOIN
tbl_RolePowers ON tbl_UserRole.RoleID = tbl_RolePowers.RoleID AND
tbl_UserRole.ProjectTypeID = tbl_RolePowers.ProjectTypeID AND
tbl_UserRole.VersionID = tbl_RolePowers.VersionID INNER JOIN
tbl_Powers ON
tbl_RolePowers.ProjectTypeID = tbl_Powers.ProjectTypeID AND
tbl_RolePowers.VersionID = tbl_Powers.VersionID AND
tbl_RolePowers.PowersID = tbl_Powers.PowersID INNER JOIN
tbl_Project ON tbl_Powers.VersionID = tbl_Project.VersionID AND
tbl_Powers.ProjectTypeID = tbl_Project.ProjectTypeID INNER JOIN
tbl_NodeStatus ON tbl_Project.ProjectID = tbl_NodeStatus.ProjectID AND
tbl_Powers.NodeID = tbl_NodeStatus.NodeID INNER JOIN
d_Exoticrecord ON tbl_Project.ProjectID = d_Exoticrecord.ProjectID
WHERE (tbl_Project.Ispigeonholed=0) and
(tbl_NodeStatus.NodeState = 2)时出现错误提示框:ORA-01652:无法通过128(在表空间TEMP中)扩展temp段。
ORA-27059:skgfrsz 无法减少文件大小
OSD-04005:SetFilePointer()失败,无法读取文件
O/S-ERROR:(OS 112)磁盘空间不足
不知如何解决,敬请指点!
解决方案 »
- group by语句如何写?
- 求高人解决
- 重建控制文件时,出现ORA-00600错误,急!!
- 郁闷
- 请教:一个关于回滚的简单问题,在线等待
- 请问有没有数据库转换的工具,比如DB2转Oricle,SQL Server转Oricle等,给分!
- ★★★急急急,各位大虾,怎么判断一个字符串是不是日期,有函数吗???
- 大家说说,统计的一般方法???100分!
- 帮助帮助我啊~~~~~~~~~~~~~~!其他论坛的人都回答不了啊~!?我该怎么做啊~?谢谢了啊
- 如果没有主键,要怎么判断唯一性
- Insert中文到Oracle遇到ora-00917 missing comma错误
- 我初学Oracle数据库,有个问题解决不了请帮忙看一下!!
oracle自动扩展temp段时,操作系统报没有空间了。
解决:
在操作系统里搞点空间
或优化SQL,减少排序类操作
如何增加temp表空间?
temp表空间对应的数据文件temp01.dbf已经达到操作系统的最大文件大小 4G。
create temporary tablespace temptest tempfile '/dev/vgqrya01/rlv_08_temp_002';
alter database default temporary tablespace temptest;
drop tablespace temp;
create temporary tablespace temp tempfile '/dev/vgqrya01/rlv_08_temp_001';
alter database default temporary tablespace temp;
drop tablespace temptest;