ORA-01658 unable to create INITIAL extent for segment in tablespace stringCause: Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created.Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL.
我现在上不了国外的网,你在technet.oracle.com下的文档中找一下,一定会有的.system表空间没有比initial大的连续空间. 这种情况如何解决呢: =>alter tablespace system coalesce;
用oerr查出的帮助信息: 01658, 00000, "unable to create INITIAL extent for segment in tablespace %s" // *Cause: Failed to find sufficient contiguous space to allocate INITIAL // extent for segment being created. // *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the // tablespace or retry with a smaller value for INITIAL 解决办法有两种: 1.增加表空间,增加后就有比Initial大的连续空间了,方法上面已有了 2.合并表空间的碎片,可以用楼上说的语句或用压缩方式exp系统,然后imp
哪里可下载到errormessage的pdf文件
修改表空间方法: 1.ALTER DATABASE DATAFILE 'F:\ORANT\DATABASE\TEST.ORA' RESIZE 6120K; 2.alter database datafile 'datafileofsystemtablespace' autoextend on; 3.alter user <theuser> default tablespace othertsthansystem; 4.alter tablespace system coalesce; 查找表空间文件: select file_name from dba_data_files where tablespace_name='SYSTEM';
2.假如是Oracle8/8i的话,可用alter tablespace coalsce来整理碎片.
3.假如原先没有autoextend,可以alter datafile autoextend on;
1.查清引发错误的操作
2.查找对就出错信息对应的解决办法(oracle上可以下载errormessage的pdf文件)你碰到的问题可能是:
1.没有扩展空间,maxsize已到
2.磁盘没空间
3.system表空间没有比initial大的连续空间.
到哪里可下载到errormessage的pdf文件
=>alter tablespace system coalesce;
01658, 00000, "unable to create INITIAL extent for segment in tablespace %s"
// *Cause: Failed to find sufficient contiguous space to allocate INITIAL
// extent for segment being created.
// *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the
// tablespace or retry with a smaller value for INITIAL
解决办法有两种:
1.增加表空间,增加后就有比Initial大的连续空间了,方法上面已有了
2.合并表空间的碎片,可以用楼上说的语句或用压缩方式exp系统,然后imp
1.ALTER DATABASE DATAFILE 'F:\ORANT\DATABASE\TEST.ORA' RESIZE 6120K;
2.alter database datafile 'datafileofsystemtablespace' autoextend on;
3.alter user <theuser> default tablespace othertsthansystem;
4.alter tablespace system coalesce;
查找表空间文件:
select file_name from dba_data_files where tablespace_name='SYSTEM';