Warning: View altered with compilation errors. : Please help.
787789Dec 22 2011 — edited Dec 22 2011Hi All,
Found few views invalid, tried to compile them, but got the following error. It looks like synonyms are calling each other.
Please help to compile the view.
=======================
SQL> alter view APPS.PER_ADDRESSES_AV12 compile;
Warning: View altered with compilation errors.
Checked error:
SQL> SHOW errors VIEW APPS.PER_ADDRESSES_AV12;
Errors for VIEW APPS.PER_ADDRESSES_AV12:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 ORA-01775: looping chain of synonyms
Extracted DDL:
==========
CREATE OR REPLACE FORCE VIEW "APPS"."PER_ADDRESSES_AV12" ("ROW_KEY", "ADDRESS_
ID", "TOWN_OR_CITY") AS
SELECT ROW_KEY, ADDRESS_ID, TOWN_OR_CITY FROM PER_ADDRESSES_A WHERE TOWN_OR_CI
TY IS NOT NULL OR SUBSTR(AUDIT_TRUE_NULLS,12,1)='Y' UNION ALL SELECT 99991231235
9591111122222 ROW_KEY, ADDRESS_ID, TOWN_OR_CITY FROM PER_ADDRESSES
Checked synonyms for the base table:
=======================
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME
------------------------------ ------------------------------ ------------------------------ ------------------------------
PUBLIC PER_ADDRESSES HR PER_ADDRESSES
APPS PER_ADDRESSES HR PER_ADDRESSES
XXHRC PER_ADDRESSES APPS PER_ADDRESSES
Edited by: 784786 on Dec 22, 2011 7:27 AM