dependencies of views
From: Norbert Winkler <norbert.winkler1_at_gmx.de>
Date: Wed, 7 Oct 2009 11:12:40 +0200
Message-ID: <265ut4rv19al.13t6fvvszhz8r$.dlg_at_40tude.net>
Hi,
FROM dba_objects
WHERE status = 'INVALID'
and owner = 'MY_SCHEMA'
ORDER BY owner, object_type, object_name;
Date: Wed, 7 Oct 2009 11:12:40 +0200
Message-ID: <265ut4rv19al.13t6fvvszhz8r$.dlg_at_40tude.net>
Hi,
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,
object_type,
object_name,
status
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.
-- Norbert Oracle9i Enterprise Edition Release 9.2.0.8.0 64BitReceived on Wed Oct 07 2009 - 04:12:40 CDT