dependencies of views

From: Norbert Winkler <>
Date: Wed, 7 Oct 2009 11:12:40 +0200
Message-ID: <265ut4rv19al.13t6fvvszhz8r$>


after migrating to Ora11 and some new synonym definitions etc. I've a lot of invalid views.
I can see them with this select

SELECT owner,


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

To find out the source of the mistake I can try to compile the first and the the next mistake. But it would be easier to order the above SELECT by depencies, so that the basic views come first and then the dependent. Is it possible.

Oracle9i Enterprise Edition Release 64Bit
Received on Wed Oct 07 2009 - 04:12:40 CDT

Original text of this message