Re: Compile All Schema

From: Tony BenBrahim <ads_at_houston.rr.com>
Date: 2000/08/10
Message-ID: <EDDD0269F0F3372D.B7729418B198FD12.0A81443331A59A30@lp.airnews.net>#1/1

Stefan.Roesch_at_t-online.de (Stefan Roesch) wrote in <3991A297.CB2F3370_at_t-online.de>:

>This is a corruption in the data dictionary dependency$ table
>Call oracle support to resolve

Not necessarily.
This can happen easily if package A mentions a variable or procedure from package B, and package B mentions a variable or procedure from package A. This is not really a problem, except that you can never get all packages to be valid MANUALLY at the same time. This is not a problem since the package will be compiled correctly the first time it is called.

>
>Fabio Franco wrote:
>
>> Oracle generate the error "ORA-01436: CONNECT BY loop in user data"
>> when i compile a schema using the command
>> "SYS.DBMS_UTILITY.COMPILE_SCHEMA".
>>
>> This message was not generated on another instance on the same Oracle
>> server.
>>
>> I work with Oracle Server version 8.1.5.
>>
>> Can anyone tell me how i can resolve this problem?
>>
>> Thanks,
>> Fabio Franco.
>
Received on Thu Aug 10 2000 - 00:00:00 CDT