Tablespace Space History doesn't show result or the error "ORA-01775: looping chain of synonyms" (4278457)

When user tries to access the Space History in the Database | Administer |  Tablespace, either  no result is generated or the following error is thrown.

ORA-01775: looping chain of synonyms

The Toad Schema needed to generate the Space Manager does not have privilege to create views.   This is necessary because the Space Manager requires the view TOAD.TOAD_SPACE_HIST to be created.

WORKAROUND 1:

1.  Login in as sys and drop the TOAD Schema.

2. Re-create the TOAD Schema by running the Server Side, but make sure to check "Grant TOAD the necessary privileges to use TOAD Space Manager"

3. Login with the TOAD Schema and run the Space Manger set up again from Database | Administer | Tablespace | Space History.

WORKAROUND 2:

1. Login as sys.

2. Go to Schema Browser | Users.

3. Double click on the TOAD user and give it CREATE VIEWS rights.

4. Run the following TOAD.TOAD_SPACE query in the Editor

CREATE OR REPLACE VIEW TOAD.TOAD_SPACE (
    TABLESPACE,
    FREE_MEGS,
    USED_MEGS,
    ALLOC_MEGS,
    PCT_FREE,
    PCT_USED
)
AS
        SELECT     TOAD.TOAD_DATA_FILES.TABLESPACE_NAME,
                          ROUND (SUM (NVL (TOAD.TOAD_FREE_SPACE.BYTES, 0)) / 1048576),
                          ROUND( (SUM (TOAD.TOAD_DATA_FILES.BYTES)
                                          - SUM (NVL (TOAD.TOAD_FREE_SPACE.BYTES, 0)))
                                      / 1048576),
                          SUM (TOAD.TOAD_DATA_FILES.BYTES) / 1048576,
                          ROUND (
                                SUM (NVL (TOAD.TOAD_FREE_SPACE.BYTES, 0))
                                / SUM (TOAD.TOAD_DATA_FILES.BYTES),
                                2
                          ),
                          1
                          - ROUND (
                                    SUM (NVL (TOAD.TOAD_FREE_SPACE.BYTES, 0))
                                    / SUM (TOAD.TOAD_DATA_FILES.BYTES),
                                    2
                              )
            FROM     TOAD.TOAD_DATA_FILES, TOAD.TOAD_FREE_SPACE
          WHERE     TOAD.TOAD_DATA_FILES.FILE_ID = TOAD.TOAD_FREE_SPACE.FILE_ID(+)
                          AND TOAD.TOAD_DATA_FILES.MON_DATE =
                                      TOAD.TOAD_FREE_SPACE.MON_DATE(+)
                          AND TOAD.TOAD_DATA_FILES.MON_DATE <= SYSDATE
    GROUP BY     TOAD.TOAD_DATA_FILES.TABLESPACE_NAME;

DROP PUBLIC SYNONYM TOAD_SPACE;
CREATE PUBLIC SYNONYM TOAD_SPACEFOR TOAD.TOAD_SPACE;
GRANT DELETE, INSERT, SELECT, UPDATE ON TOAD.TOAD_SPACE TO PUBLIC;

5. Run the following TOAD.TOAD_SPACE_HIST query in the Editor.

 CREATE OR REPLACE FORCE VIEW TOAD.TOAD_SPACE_HIST (
    file_id,
    TABLESPACE,
    mdate,
    usedspace
)
AS
        SELECT     a.file_id,
                          a.tsp,
                          a.mdate,
                          ROUND (SUM (a.SPACE) / 1048576)
            FROM     (   SELECT     toad.toad_data_files.file_id file_id,
                                                  toad.toad_data_files.tablespace_name tsp,
                                                  toad.toad_data_files.mon_date mdate,
                                                  SUM (toad.toad_data_files.BYTES)
                                                  - SUM (NVL (toad.toad_free_space.BYTES, 0))
                                                        SPACE
                                    FROM     toad.toad_data_files, toad.toad_free_space
                                  WHERE     toad.toad_data_files.file_id =
                                                        toad.toad_free_space.file_id(+)
                                                  AND toad.toad_data_files.mon_date =
                                                              toad.toad_free_space.mon_date(+)
                            GROUP BY     toad.toad_data_files.file_id,
                                                  toad.toad_data_files.tablespace_name,
                                                  toad.toad_data_files.mon_date) a
    GROUP BY     file_id, tsp, mdate;

DROP PUBLIC SYNONYM TOAD_SPACE_HIST;
CREATE PUBLIC SYNONYM TOAD_SPACE_HIST FOR TOAD.TOAD_SPACE_HIST;
GRANT DELETE, INSERT, SELECT, UPDATE ON TOAD.TOAD_SPACE_HIST TO PUBLIC;