Re: dependencies of views
Date: Wed, 7 Oct 2009 18:13:28 +0200
"Norbert Winkler" <norbert.winkler1_at_gmx.de> a écrit dans le message de news: 265ut4rv19al.13t6fvvszhz8r$.dlg_at_40tude.net...
| 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 188.8.131.52.0 64Bit
Michel Received on Wed Oct 07 2009 - 11:13:28 CDT