I got ” ORA-39082 object type create with compilation errors” error in Oracle database.
ORA-39082 object type create with compilation errors
Details of error are as follows.
ORA-39082: Object type string created with compilation warnings Cause: The object in the SQL statement following this error was created with compilation errors. If this error occurred for a view, it is possible that the base table of the view was missing. Action: This is a warning. The object may have to be recompiled before being used.
When importing PL/SQL objects, getting errors during the import and afterwards the objects will not compile: ORA-39082: Object type PACKAGE_BODY:"<SCHEMA_NAME1>"."<PACKAGE_NAME1>" created with compilation warnings ORA-39082: Object type PACKAGE_BODY:"<SCHEMA_NAME1>"."<PACKAGE_NAME2>" created with compilation warnings ORA-39082: Object type PACKAGE_BODY:"<SCHEMA_NAME2>"."<PACKAGE_NAME3>" created with compilation warnings ORA-39082: Object type PACKAGE_BODY:"<SCHEMA_NAME2>"."<PACKAGE_NAME4>" created with compilation warnings
Object type string created with compilation warnings
This ORA-39082 error is related with the object in the SQL statement following this error was created with compilation errors. If this error occurred for a view, it is possible that the base table of the view was missing.
This is a warning. The object may have to be recompiled before being used.
To solve this error, run utlrp.sql ( under $ORACLE_HOME/rdbms/admin ) to compile all invalid objects.
SQL> @utlrp.sql
The issue is addressed in unpublished
Bug 20412068 – ORA-39082 WHEN IMPORTING PLSQL OBJECTS
The bug is fixed in 12.2.
To solve the issue, use any of below alternatives:
- Apply interim patch 20412068, if available for your platform and Oracle version.
The patch should be applied on the target database.To check for conflicting patches, please use the MOS Patch Planner Tool
Please refer to
Note 1317012.1 – How To Use MOS Patch Planner To Check And Request The Conflict Patches?If no patch exists for your version, please contact Oracle Support for a backport request.
– OR –
- As a workaround:
-
- get a copy of the source code from the source database for the PL/SQL objects for which the error occurs on the import
- then recreate the objects on the target database
- afterwards recompile the involved objects on the target db
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )