ORA-01658 unable to create INITIAL extent for segment in tablespace string
上一篇 /
下一篇 2009-03-26 11:35:41
/ 个人分类:ORACLE
在导库时出现:
ORA-01658 unable to create INITIAL extent for segment in tablespace string
具体原因:
ORA-01658 unable to create INITIAL extent for segment in tablespace string
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.
解决方法:
有2个方法:
1。增大现在表空间数据文件的大小.alter database datafile 'XXX' resize XXXXM;
2。给这个表空间增加数据文件:alter tablespace XXX add datifile 'XXX' size XXXM autoextend on next XXM maxsize XXXXM;
收藏
举报
TAG: