dependencies of views

#1

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

#2

"Norbert Winkler" <norbert.winkler1 (AT) gmx (DOT) de> a écrit dans le message de news: 265ut4rv19al.13t6fvvszhz8r$.dlg (AT) 40tude (DOT) net...

Quote:

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/d...ScriptIdA=1236
http://www.dba-village.com/dba/villa...ScriptIdA=1237

Regards
Michel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

dependencies of views

comp.databases.oracle.misc comp.databases.oracle.misc

dependencies of views - 10-07-2009 , 04:12 AM

Re: dependencies of views - 10-07-2009 , 11:13 AM