Site icon IT Tutorial

ORA-39082 object type create with compilation errors

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:

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

Exit mobile version