In Toad 9.7.0 Oracle 11g databases are showing blank graphs on the Space History (48441)

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)