ORA-39029: worker with process name prematurely terminated ORA-01771: looping chain of synonyms ORA-32701: Possible hangs up to hang detected ORA-04020: deadlock detected while trying to lock object ORA-04021: timeout occurred while waiting to lock object ORA-00060: deadlock detected while waiti...
impdp导数据,出现ORA-39082 ORA-39083错误号,对象无法编译 导入结束后可以通过编译对象来尝试: alter view view_name compile; 如果报错: 使用show errors定位问题所在源,是权限的问题还是dblink的问题; 如果是权限问题,说明之前创建用户时没有给足够的用户权限(主要是对一些表的读权限) 主要查询以下两个视图:dba_sy...
Oracle Database - Standard Edition - Version 10.1.0.2 to 10.2.0.4 [Release 10.1 to 10.2]: IMPDP - ORA-39082 (Object Type TYPE Created With Compilation Warnings) When
ORA-39082: Object type PACKAGE_BODY:"<SCHEMA_NAME1>"."<PACKAGE_NAME1>" created withcompilation warningsORA-39082: Object type PACKAGE_BODY:"<SCHEMA_NAME1>"."<PACKAGE_NAME2>" created withcompilation warningsORA-39082: Object type PACKAGE_BODY:"<SCHEMA_NAME2>"."<PACKAGE_NAME3>" created ...
ORA-39082: Object type VIEW:"SDE"."GDB_ITEMRELATIONSHIPS_VW" created with compilation warnings These problematic views can be fixed by manually compiling them, or executing the SYS.UTL_RECOMP package against the schema containing these erroneous views: ...
ORA-39082: Object type ALTER_FUNCTION:"SCHEMAS_NAME"."XXX_XXX_XXX" created with compilation warnings ORA-39082: Object type PACKAGE_BODY:"SCHEMAS_NAME"."XXX_XXX_XXX" created with compilation warnings 1. 2. 3. ##我是这样处理 SQL> exec dbms_utility.compile_schema('SCHEMAS_NAME'); ...
ORA-39082: Object type VIEW:"SDE"."GDB_ITEMRELATIONSHIPS_VW" created with compilation warnings These problematic views can be fixed by manually compiling them, or executing the SYS.UTL_RECOMP package against the schema containing these erroneous views: ...
ORA-31684: 对象类型 INDEX:"SDE"."A12_IX1" 已存在 ORA-31684: 对象类型 INDEX:"SDE"."A13_IX1" 已存在 ORA-39082: 对象类型 PACKAGE BODY:"SDE"."LOCK_UTIL" 已创建, 但带有编译警告 ORA-39082: 对象类型 PACKAGE BODY:"SDE"."PINFO_UTIL" 已创建, 但带有编译警告 ...
ORA-39082: Object type PACKAGE_BODY:"BMI"."PKG_SUSPICIOUS_AMOUNT" created with compilation warnings ORA-39082: Object type PACKAGE_BODY:"BMI"."PKG_SYNCDATA_PERMONTH" created with compilation warnings Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT ...
ORA-39082: Object type VIEW:"SDE"."GDB_ITEMS_VW" created with compilation warnings ORA-39082: Object type VIEW:"SDE"."GDB_ITEMRELATIONSHIPS_VW" created with compilation warnings These problematic views can be fixed by manually compiling them, or executing the SYS.UTL_RECOMP package...