This content has been marked as final. Show 6 replies
I'll have to take a look at the drill down link, but for now here's how to find the invalid objects from the db itself:
From the DB target, Select Schema -> Programs -> Packages, then select Invalid for status, select your schema and click Go. This will bring back the list of Invalid objects.
In Selection Mode, you can select Multiple to be able to select multiple invalid and select Actions -> Compile.
You can change Object Type in the drop down on the top right.
Thanks, it's a step in the right direction. I can see if something under PROGRAM is INVALID, but can't see if a database object is, such as a VIEW, MATERIALIZED VIEW, SYNONYM, etc.
I have the em12c r2 documentation, but any references to invalid objects takes me to the metric setting, not what I'm looking for.
Any help would be appreciated. For now we've resorted to using TOAD and a script, but we'd much prefer to use EM.
You can do the same thing for views/syn by going to Schema -> Database Objects.
I don't have access to a 10g site, when I checked 11g I could only get as far as Schema, never saw a drill down to the actual object name. What I would suggest is to log an SR, and provide screenshots of the steps you take to get there in 10g (if you still have a site), and as far as it will let you get in 12c. Update the thread w/ the SR # as well.
Latest message from Oracle support:
As far as I know that is the only way to view/compile the invalid objects from 12c Console, this way has been completely changed than the previous releases, I am sorry to confirm that you will lose the functionality after upgrade.
Global Customer Support | Enterprise Manager Team