ORA-01659: unable to allocate MINEXTENTS beyond string in tablespace string Cause: Failed to find sufficient contiguous space to allocate MINEXTENTS for the segment being created.
Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with smaller value for MINEXTENTS, NEXT or PCTINCREASE 先看一下表空间可满了.. ------------------------------------------------------------------------------ Blog: http://blog.csdn.net/tianlesoftware 网上资源: http://tianlesoftware.download.csdn.net 相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850 DBA 超级群:63306533; 聊天 群:40132017 --加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
表空间不足,改进方法 1.添加数据文件到表空间 alter tablesapce xxx add datafile ''; 2.增大表空间数据文件的大小 alter datafile dataid resize xxM; 3。把数据文件设置为自动扩展 alter datafile dataid autoextend on;
楼上正解,申请新的extents的动作失败。
alter tablespace xxx add datafile '/app/xxx/xxx.dbf' size 1000M autoextend on next 50M maxsize 5000M ;扩展表空间大小吧,空间不足了
Cause: Failed to find sufficient contiguous space to allocate MINEXTENTS for the segment being created.
Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with smaller value for MINEXTENTS, NEXT or PCTINCREASE
先看一下表空间可满了..
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977(满)
DBA3 群:62697850 DBA 超级群:63306533;
聊天 群:40132017
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
1.添加数据文件到表空间
alter tablesapce xxx add datafile '';
2.增大表空间数据文件的大小
alter datafile dataid resize xxM;
3。把数据文件设置为自动扩展
alter datafile dataid autoextend on;