amrahman

How to fix invalid object(s) from nikuadmin db compile

Discussion created by amrahman on Jan 17, 2013
Latest reply on Jan 22, 2013 by Chris_Hackett
Hi everyone,

While running the "nikuadmin db compile" command, I get a list of invalid objects as follows:
Compiling database objects...
==========================================
DBTools Log - Thu Jan 17 12:25:56 EST 2013
==========================================
Command: compile
Compiling the database....
        Following object(s) are invalid:
                ODF_COP_QUALITY_ATTRIB_V
                ODF_COP_QUALITY_ATTRIB_V2
                ODF_COP_PGM_MGMT_PLAN_V2
                ODF_COP_PGM_MGMT_PLAN_V
                ODF_COP_SCOPE_V2
                ODF_COP_SCOPE_V
Total time: 0H:0M:1S
The installation documentation states to execute the following as sysdba to fix it:
SQL> EXEC UTL_RECOMP.recomp_serial(‘NIKU’);
After executing this statement, I still get those object compilation errors.
Any suggestions on how to fix these invalid objects?

Thanks!

Outcomes