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:

  • 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 )

 

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *