impdp 时候遭遇等待事件statement suspended, wait error to be cleared。
问题分析：
经过查验为导入设定的表空间空间不足造成的，只需要把表空间扩大这个错误就自然消失，导入不会终端。
具体的日志如下：
21:18:00 (2.0 min) 1,204 statement suspended, wait erro 939 8.21 CPU + Wait for CPU 264 2.31 db file sequential read 1 0.01 21:20:00 (2.0 min) 1,201 statement suspended, wait erro 951 8.32 CPU + Wait for CPU 249 2.18 control file sequential read 1 0.01 21:22:00 (2.0 min) 1,197 statement suspended, wait erro 942 8.24 CPU + Wait for CPU 255 2.23 21:24:00 (2.0 min) 1,201 statement suspended, wait erro 960 8.40 CPU + Wait for CPU 241 2.11 21:26:00 (2.0 min) 1,215 statement suspended, wait erro 963 8.42 CPU + Wait for CPU 250 2.19 log file parallel write 2 0.02 21:28:00 (2.0 min) 1,201 statement suspended, wait erro 952 8.33 CPU + Wait for CPU 249 2.18 21:30:00 (2.0 min) 1,202 statement suspended, wait erro 956 8.36 CPU + Wait for CPU 246 2.15 21:32:00 (2.0 min) 1,202 statement suspended, wait erro 950 8.31 CPU + Wait for CPU 252 2.20 21:34:00 (2.0 min) 1,199 statement suspended, wait erro 944 8.26 CPU + Wait for CPU 254 2.22 db file sequential read 1 0.01 21:36:00 (1 secs) 10 statement suspended, wait erro 8 0.07 CPU + Wait for CPU 2 0.02 ------------------------------------------------------------- End of Report Report written to awrrpt_1_4_5.txt SQL> SQL> SQL> SQL> select event from v$session_wait where wait_class#<>6; EVENT ---------------------------------------------------------------- SQL*Net message to client statement suspended, wait error to be cleared db file scattered read statement suspended, wait error to be cleared statement suspended, wait error to be cleared statement suspended, wait error to be cleared statement suspended, wait error to be cleared statement suspended, wait error to be cleared db file sequential read statement suspended, wait error to be cleared statement suspended, wait error to be cleared Completed: alter tablespace lisdata add datafile '+DATA01' size 4116m Mon Dec 30 21:40:17 2013 statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_02.1' was resumed Mon Dec 30 21:40:17 2013 statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_02.1' was resumed Mon Dec 30 21:40:18 2013 statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_02.1' was resumed Mon Dec 30 21:40:18 2013 statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_02.1' was resumed Mon Dec 30 21:40:18 2013 statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_02.1' was resumed Mon Dec 30 21:40:18 2013 statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_02.1' was resumed Mon Dec 30 21:40:18 2013 statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_02.1' was resumed Mon Dec 30 21:40:18 2013 statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_02.1' was resumed Mon Dec 30 21:40:50 2013 alter tablespace lisdata add datafile '+DATA01' size 4116m Mon Dec 30 21:41:02 2013 Completed: alter tablespace lisdata add datafile '+DATA01' size 4116m Mon Dec 30 21:41:44 2013 alter tablespace lisdata add datafile '+DATA01' size 4116m Mon Dec 30 21:41:59 2013 Completed: alter tablespace lisdata add datafile '+DATA01' size 4116m Mon Dec 30 21:44:25 2013 alter tablespace lisdata add datafile '+DATA01' size 4116m Mon Dec 30 21:44:31 2013 statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_02.1' was suspended due to ORA-01652: unable to extend temp segment by 1024 in tablespace LISDATA Mon Dec 30 21:44:31 2013 statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_02.1' was suspended due to ORA-01652: unable to extend temp segment by 1024 in tablespace LISDATA Mon Dec 30 21:44:31 2013 statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_02.1' was suspended due to ORA-01652: unable to extend temp segment by 1024 in tablespace LISDATA Completed: alter tablespace lisdata add datafile '+DATA01' size 4116m statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_02.1' was resumed statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_02.1' was resumed statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_02.1' was resumed
