Return
-
Title
In Toad 9.7.0 Oracle 11g databases are showing blank graphs on the Space History -
Description
In Toad 9.7.0, Oracle 11g databases are showing blank graphs on the Space History Usage screen.
-
Cause
Getting an ORA-01775 looping chain error.
SELECT Tablespace, MDate, Sum(UsedSpace) Used FROM TOAD_SPACE_HIST
GROUP BY Tablespace, MDate
Runtime error occurred: 1775 (ORA-01775: looping chain of synonyms)
Cause: Through a series of CREATE synonym statements, a synonym was defined that referred to itself. For example, the following definitions are circular:
CREATE SYNONYM s1 for s2 CREATE SYNONYM s2 for s3 CREATE SYNONYM s3 for s1 -
Resolution
Please recreate the objects (views TOAD_SPACE and TOAD_SPACE_HIST)