ORA-39126: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS [SELECT old_value FROM "YKSOFT"."SYS_IMPORT_FULL_01" 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 8164
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x99e7d370     19028  package body SYS.KUPW$WORKER
0x99e7d370      8191  package body SYS.KUPW$WORKER
0x99e7d370      8980  package body SYS.KUPW$WORKER
0x99e7d370      1651  package body SYS.KUPW$WORKER

这样啊的错误首先看ORA-25153 是因为没有表空间文件

select tablespace_name,status from dba_tablespaces;
TABLESPACE_NAME                STATUS
------------------------------ ---------
SYSTEM                         ONLINE
UNDOTBS1                       ONLINE
SYSAUX                         ONLINE
TEMP                           ONLINE
USERS                          ONLINE

查看一下temp文件

select tablespace_name,file_name from dba_temp_files;

没有看到数据文件

所有添加一个临时表空间的数据文件

alter tablespace temp add tempfile /u01/app/oradata/TEMP01.DBF' size 300M;

ORA-39126从网上查到一些资料说是因为一个数据库的bug的问题