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:

 

评分:0

我来说两句

Open Toolbar