临时表空间不足居然报IO错误。

Insert 时：

14:18:36 SQL> insert /*+APPEND */ into metric_data_hourly
14:18:36 2 select * from metric_hold
14:18:36 3 where datetime > to_timestamp_tz('10-FEB-09 19.00.00 -05:00','DD-MON-YY HH24:MI:SS TZH:TZM');
insert /*+APPEND */ into metric_data_hourly *
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error

IMPORT 时：

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "SGREPORTS"."SYS_IMPORT_TABLE_03" stopped due to fatal error at 21:23:27
ORA-39014: One or more workers have prematurely exited.
I guess the import has happened the error.
Could you please help see the IO error first?
ORA-01114: IO error writing block to file 1024 (block # 150017)
ORA-27063: number of bytes read/written is incorrect

查看Alert log:

/orahome01/admin/CNSRPT/udump/cnsrpt_ora_13811.trc:
ORA-01114: IO error writing block to file 1024 (block # 150017)
ORA-27063: number of bytes read/written is incorrect
Additional information: 57344
Additional information: 253952
ORA-01114: IO error writing block to file 1024 (block # 150017)
ORA-27063: number of bytes read/written is incorrect
Additional information: 57344
Additional information: 253952
ORA-01114: IO error writing block to file 1024 (block # 150017)
ORA-27063: number of bytes read/written is incorrect
Additional information: 57344
Additional information: 253952
ORA-01114: IO error writing block to file 1024 (block # 150017)
ORA-27063: number of bytes read/written is incorrect
Additional information: 57344
Additional information: 253952

无论insert还是import都失败了。

加大TEMP表空间后上操作才成功。