![Like](http://oracledbahub.com/wp-content/plugins/wti-like-post/p_w_picpaths/pixel.gif)
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.
|
During import following error comes
ORA-39082: Object type ALTER_FUNCTION:FUNCTION_NAME created with compilation warnings
Workaround:
Recompile the invalid objects:
ALTER FUNCTION FUNCTION_NAME COMPILE;
or
exec dbms_utility.compile_schema(‘SCHEMA_NAME’);
or
Execute the Oracle-supplied utility to compile invalid objects globally:
Login as sys with SQLPLUS:
Sqlplus “/as sysdba”
SQL> @ORACLE_HOME/rdbms/admin/utlrp