Oracle 12.2在导出的时候,出现ORA-31693、ORA-02354、ORA-39826错误
ORA-31693: Table data object "YKSOFT"."T_TEMP_U90915" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-39826: Direct path load of view or synonym (YKSOFT.T_TEMP_U90915) could not be resolved.
该报错是由于在导出的时候该对象备删除导致,到数据库中查询该对象
SQL> col owner for a15
SQL> col object_name for a45
SQL> set linesize 200
SQL> select owner,object_name,object_type from dba_objects where object_name like '%90915%';
OWNER OBJECT_NAME OBJECT_TYPE
--------------- --------------------------------------------- -----------------------
YKSOFT T#U90915_GZ_PK_1 INDEX
YKSOFT T#U90915_GZ TABLE
YKSOFT TEMP_U90915 TABLE
YKSOFT TEMP_U90915_PK_1 INDEX
YKSOFT TEMP_U90915_INDEX INDEX
确实没有YKSOFT.T_TEMP_U90915了,跟业务部门沟通该对象是人为手工删除,此报错可忽略。