[Schema Browser -> View -> Status: Invalid] Why invalid?

Toad for Oracle
1

Hi folks

Why status invalid? Is there a reason or more logs? In the “Data” tab
everything looks fine.

cheers Sven

2

Unless there are errors in the view (which is not the case here since you can
see data), there is no way that I know of to tell what made the view go invalid.

Oracle may have flagged it as invalid because some DDL was performed on one of
the objects used by the view. It looks like this is what happend for you, since
you can still see data. The view may have revalidated itself when you did that.
If you hit refresh does it show as valid now?

3

It could be that the view not automatically revalidates itself. The user who is
using the view could have not the correct rights for changing that. So it is
better to validate all the views through a user that has enough rights. It could
have consequences again for your packages, because package variables could be
lost because of recompiling of the code. In that case all the users must log off
and on again.

Groetjes,
Wim

On Wed, Sep 15, 2010 at 15:12, John Dorlon wrote:

Unless there are errors in the view (which is not the case here since you
can see data), there is no way that I know of to tell what made the view go
invalid.

 

Oracle may have flagged it as invalid because some DDL was performed on one
of the objects used by the view.   It looks like this is what happend for
you, since you can still see data.  The view may have revalidated itself
when you did that.    If you hit refresh does it show as valid now?
4

On Wed, Sep 15, 2010 at 3:12 PM, John Dorlon wrote:

Unless there are errors in the view (which is not the case here since you can see data), there is no way that I know of to tell what made the view go invalid.
Oracle may have flagged it as invalid because some DDL was performed on one of the objects used by the view. It looks like this is what happend for you, since you can still see data. The view may have revalidated itself when you did that. If you hit refresh does it show as valid now?

Hi John

thanks. After refresh they are still invalid.

I found out that we have much more "invalid" objects in schema:

SELECT owner,
object_type,
object_name,
status
FROM dba_objects
WHERE status = 'INVALID'
ORDER BY owner, object_type, object_name;

we never had a problem, so I won't recompile the objects.

cheers Sven