Glenn,
There is a very simple reason for this : self-referencing objects
(or, more vicious, objects indirectly referencing themselves). I think
that most recompile_invalid_objects scripts handle self-referencing
objects properly, indirect references are harder to deal with. FYI there
is a script on our site helping you identify tables which indirectly
self-reference themselves; not sure that it also handles views, packages
and the like, but it can be easily adapted. Recompile manually the few
'problem' objects, then your script may run without any hiccup ...
--
Regards,
Stephane Faroult
email: sfaroult_at_oriolecorp.com
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax: +44 (0) 7050-696-449
Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------
>
> select * from sys.order_object_by_dependency
> *
> ERROR at line 1:
> ORA-01436: CONNECT BY loop in user data
>
> Anyone seen this? Got an explanation...?
>
> I was running one of the numerous
>
>
> --
> Author: Glenn Travis
> INET: Glenn.Travis_at_wcom.com
Received on Fri Sep 08 2000 - 04:41:00 CDT
