dependencies of views
Date: Wed, 7 Oct 2009 11:12:40 +0200
after migrating to Ora11 and some new synonym definitions etc.
I've a lot of invalid views.
I can see them with this select
object_type, object_name, status
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.
-- Norbert Oracle9i Enterprise Edition Release 18.104.22.168.0 64BitReceived on Wed Oct 07 2009 - 04:12:40 CDT