|
-
Env: Oracle 8.1.6+context, Sparc Solaris.
No one schema could be compiled... I tried it from sqlplus, from svrmgrl - result is the same:
SQL> exec dbms_utility.compile_schema('SYS');
BEGIN dbms_utility.compile_schema('SYS'); END;
*
ERROR at line 1:
ORA-01436: CONNECT BY loop in user data
ORA-06512: at "SYS.DBMS_UTILITY", line 195
ORA-06512: at line 1
All views are VALID. Some packages are INVALID, I`m trying to compile them manually, but it could take a lot of time...
Can anyone tell me - what could be a reason of that error?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|