impdp导入用户sechema ORA-39082 impdp导数据,出现ORA-39082 ORA-39083错误号,对象无法编译 导入结束后可以通过编译对象来尝试: alter view view_name compile; 如果报错: 使用show errors定位问题所在源,是权限的问题还是dblink的问题; 如果是权限问题,说明之前创建用户时没有给足够的用户权限(主要是对一些表的读权限...
###sample 2ORA-39082: Object type string created with compilation warnings March 5th, 2011 rishi 0 During import following error comes ORA-39082: Object type ALTER_FUNCTION:FUNCTION_NAME created with compilation warnings Workaround: Recompile the invalid objects: \\\ sys用户查看无效对象: col obje...
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-31693: Table data object "MAP"."PARCELS" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-00600: internal error code, arguments: [kpudpxcs_ctxConvertStream_ref_1], [SYS_TYPEID("SHAPE")], [], [], [], [], [], [], ...
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 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 against the...
ORA-39082: Object type PACKAGE_BODY:"BMI"."PKG_SYNCDATA_PERMONTH" created with compilation warnings Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Job "ZHUL"."SYS_IMPORT_SCHEMA_01" completed with 14 error(s...
ORA-39082: 对象类型 PACKAGE BODY:"SDE"."LOCK_UTIL" 已创建, 但带有编译警告 ORA-39082: 对象类型 PACKAGE BODY:"SDE"."PINFO_UTIL" 已创建, 但带有编译警告 ORA-39082: 对象类型 PACKAGE BODY:"SDE"."VERSION_USER_DDL" 已创建, 但带有编译警告 ...
impdp导入用户sechema ORA-39082 2014-02-09 21:42 −impdp导数据,出现ORA-39082 ORA-39083错误号,对象无法编译 导入结束后可以通过编译对象来尝试: alter view view_name compile; 如果报错: 使用show errors定位问题所在源,是权限的问题还是dblink的问题; 如... ...
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 against the...