Re: dependencies of views

"Norbert Winkler" <norbert.winkler1_at_gmx.de> a écrit dans le message de news: 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 64Bit

http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=1236 http://www.dba-village.com/dba/village/dvp_scripts.ScriptDetails?ScriptIdA=1237

Regards
Michel Received on Wed Oct 07 2009 - 11:13:28 CDT