How do I determine what a red 'X' means

[manningda]

Fairly young database experience, so apologies in advance if this seems an obvious question...

Have a series of views Im having to review in response to a support request for an Oracle 9i Db we did not develop.

Using PL/SQL developer to review the code and noticing in the browser all VIEW icons are marked with a RED 'X'.

For packages and proceedures have figured out this typically means a "broken" or "un-compiled" state, but what does this mean for a view?

The portion of the application that references the view does not appear to be the source of the issue and the view appears to be returning valid data when queried.

Tried to do some review in the help sys, but no reference to the icon "codes" that I can see.

Is there a method/way to determine why the red X is being posted for this object?

Thanks in advance for the help!

 

[Marco Kalter]

The red X means "Invalid". This means that the object (a program unit or view) references another object that has been altered since it was successfully compiled. It can also be that the object was compiled with errors.

You can use the "Compile Invalid Objects" tool to recompile, and thereby validate, all invalid objects.