 |
|
| Computers Forum Index » Computer - Databases - Oracle (Misc) » dependencies of views... |
|
Page 1 of 1 |
|
| Author |
Message |
| Norbert Winkler... |
 Posted: Wed Oct 07, 2009 1:12 pm |
|
|
|
Guest
|
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 |
|
|
| Back to top |
|
|
|
| Michel Cadot... |
| Posted: Wed Oct 07, 2009 8:13 pm |
|
|
|
Guest
|
"Norbert Winkler" <norbert.winkler1 at (no spam) gmx.de> a écrit dans le message de news: 265ut4rv19al.13t6fvvszhz8r$.dlg at (no spam) 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 |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Tue Dec 08, 2009 8:33 am
|
|