这是因为你的下一个分配空间太小了,用这个语句修改
ALTER ROLLBACK SEGMENT R01 STORAGE(NEXT 10M OPTIMAL 10M);
然后IMP的时候把BUFFER加大
IMP 。。 BUFFER=20480000
ALTER ROLLBACK SEGMENT R01 STORAGE(NEXT 10M OPTIMAL 10M);
然后IMP的时候把BUFFER加大
IMP 。。 BUFFER=20480000
缺省 N
解释 A value of Y specifies that Import should commit after
each array insert. By default, Import commits only after
loading each table, and Import performs a rollback
when an error occurs, before continuing with the next
object. Specifying COMMIT=Y prevents rollback
segments from growing inordinately large.