oracle error 30036,IMP-00058: ORACLE error 30036 encountered ORA-30036: unable to extend segment by ...

前天别人传了一个大的dmp文件过来，要导入数据。结果报错了：

IMP-00058: ORACLE error 30036 encountered ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

目前用的确实比较小，就打算重建。

1. 新增一个undo tablespace.

SQL> create undo tablespace UNDOTBS2 datafile '/****/undotbs002.dbf' size 1M extent management local;

Tablespace created.

SQL>

2. 设置使用新增的undo tablespace.

SQL> alter system set undo_tablespace=UNDOTBS2 scope=both;

System altered.

SQL>

3. 删除。

SQL> drop tablespace UNDOTBS1 including contents and datafiles cascade constraints;

Tablespace dropped.

SQL>

4. 重建

SQL> create undo tablespace UNDOTBS1 DATAFILE '/****/undotbs01.dbf' SIZE 2048M EXTENT MANAGEMENT LOCAL;

Tablespace created.

SQL>

5. 设置使用新的

SQL> alter system set undo_tablespace=UNDOTBS1 scope=both;

System altered.

SQL>

6. 删除临时undo tablespace.

SQL> drop tablespace UNDOTBS2 including contents and datafiles cascade constraints;

Tablespace dropped.

SQL>

OK!