ORA-01659: unable to allocate MINEXTENTS beyond 78 in tablespace test201

wwmb · 发表于 2002-8-6 19:35

我导入数据时，出现下面的错误,请问这是为什么，我该如何修改表空间呢

test201 是目标数据库的表空间，

IMP-00003: ORACLE 错误1659出现
ORA-01659: unable to allocate MINEXTENTS beyond 78 in tablespace test201
IMP-00058: ORACLE 错误1653出现
ORA-01653: unable to extend table test.test_ERRORLOG0326 by 128 in tablespace test201
IMP-00003: ORACLE 错误1658出现
ORA-01658: unable to create INITIAL extent for segment in tablespace test201

aaahhh · 发表于 2002-8-6 20:27

no free space left in tablespace test201 ?

tiantianoracle · 发表于 2002-8-6 20:40

向test201 添加数据文件。

alter tablespace test201 add datafile '*****' size 1000M;

david_ch · 发表于 2002-8-8 13:46

先IMPORT查表结构定义，修改Minextents的大小，然后创建表结构，再导入表

chwchw · 发表于 2002-8-8 15:48

[IMP-00003: ORACLE 错误1659出现
ORA-01659: unable to allocate MINEXTENTS beyond 78 in tablespace test201
IMP-00058: ORACLE 错误1653出现
ORA-01653: unable to extend table test.test_ERRORLOG0326 by 128 in tablespace test201
IMP-00003: ORACLE 错误1658出现
ORA-01658: unable to create INITIAL extent for segment in tablespace test201
[/B][/QUOTE]
-------------------------

增加数据文件或将tablespace的minextent,next,intial等参数设小一点，表空间没有足够大的连续的extents

ORA-01659: unable to allocate MINEXTENTS beyond 78 in tablespace test201

Re: ORA-01659: unable to allocate MINEXTENTS beyond 78 in tablespace test201

浏览过的版块