In Toad 9.7.0, Oracle 11g databases are showing blank graphs on the Space History Usage screen.
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
Please recreate the objects (views TOAD_SPACE and TOAD_SPACE_HIST)
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy