ORA-39002: invalidoperation
ORA-39126: Workerunexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS [SELECT old_valueFROM
"SYS"."SYS_IMPORT_FULL_02"WHERE process_order = :1]
ORA-25153: TemporaryTablespace is Empty
ORA-06512: at"SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at"SYS.KUPW$WORKER", line 9001
----- PL/SQL Call Stack -----
object line object
handle number name
0x8a919ab0 20462 package body SYS.KUPW$WORKER
0x8a919ab0 9028 package body SYS.KUPW$WORKER
0x8a919ab0 9831 package body SYS.KUPW$WORKER
0x8a919ab0 1775 package body SYS.KUPW$WORKER
0x8394b288 2 anonymous block
ORA-39126: Worker unexpected fatal error inKUPW$WORKER.DISPATCH_WORK_ITEMS [SELECT old_value FROM
"SYS"."SYS_IMPORT_FULL_02"WHERE process_order = :1]
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_SYS_ERROR",line 95
ORA-06512: at "SYS.KUPW$WORKER",line 9001
----- PL/SQL Call Stack -----
object line object
handle number name
0x8a919ab0 20462 package body SYS.KUPW$WORKER
0x8a919ab0 9028 package body SYS.KUPW$WORKER
0x8a919ab0 9831 package body SYS.KUPW$WORKER
0x8a919ab0 1775 package body SYS.KUPW$WORKER
0x8394b288 2 anonymous block
ORA-06512: at"SYS.DBMS_SWRF_INTERNAL", line 1717
ORA-06512: at line 3
begin
*
ERROR at line 1:
ORA-20106: AWR tables do not exist for the'AWR_STAGE' user
ORA-06512: at"SYS.DBMS_SWRF_INTERNAL", line 2920
ORA-00942: table or view does not exist
ORA-06512: at line 3
... Dropping AWR_STAGE user
End of AWR Load
在MOS 上搜了一下，N多相关的bug，看了一下，都于我这里的情况不一样：
SQL> select grantee, privilege
2 from dba_tab_privs
3 where table_name='DBMS_METADATA';
PUBLIC EXECUTE
SQL>
SQL> select tablespace_name,file_namefrom dba_temp_files;
SQL>
仔细看一下错误提示，提示Temp 表空间为空：
ORA-25153: TemporaryTablespace is Empty
检查一下：
SQL> select tablespace_name,status fromdba_tablespaces;
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
USERS ONLINE
UNDOTBS2 ONLINE
DAVE ONLINE
UNDO_DAVE ONLINE
DAVE2 ONLINE
DAVE3 ONLINE
DAVE4 ONLINE
SQL>
表空间存在，但是查询数据文件：
SQL> select tablespace_name,file_namefrom dba_temp_files;
没有结果。
[oracle@dave dave]$ pwd
/u01/app/oracle/oradata/dave
[oracle@dave dave]$ ls
ANQING example.299.819454355 group_3.263.819459415 sysaux.257.816661033 thread_2_seq_11.303.819501417
anqing.297.819454405 fda1.269.819454467 group_4.261.816662239 sysaux.285.819454151 ts1.291.819454507
assm.295.819454467 fda2.270.819454491 group_4.266.819459423 system.256.816661027 ts2.288.819454533
control01.ctl fda3.293.819454493 group_5.259.816661313 system.290.819454153 undo_dave.dbf
dave01.dbf fda4.292.819454507 mssm.296.819454441 temp01.dbf undotbs1.258.816661037
dave02.dbf group_1.257.816661301 stdredo10.log temp.262.819462677 undotbs1.268.819454441
dave03.dbf group_1.286.819454681 stdredo11.log temp.264.816661353 undotbs1.dbf
dave04.dbf group_1.311.819454689 stdredo6.log temp.289.819454715 undotbs2.265.816661787
dave05.dbf group_2.294.819454693 stdredo7.log thread_1_seq_10.302.819501057 users.259.816661039
dave.298.819454401 group_2.310.819454695 stdredo8.log thread_1_seq_9.300.819500889 users.287.819454533
DAVE_ST group_3.260.816662233 stdredo9.log thread_2_seq_10.304.819501075
[oracle@dave dave]$
但实际上，物理有这个文件。 应该是之前做测试的时候，忘记做这个操作了，按照dave的习惯，在数据迁移完成后，我都会重