Possible bug in Commercial 12.0.0.61 Tablespace Space History

Toad for Oracle
1

Hi all,

In the new version when I go to Database\Administer\Tablespaces\Space History unless I check the By Datafile check box the graph doesn’t display anything.

When I spool the output and refresh the page is see this error in the Output scroll:

Session: @
Timestamp: 15:07:46.595
SELECT Tablespace, MDate, Sum(UsedSpace) Used
FROM TOAD_SPACE_HIST
GROUP BY Tablespace, MDate
SELECT UNIQUE fs.File_ID, Tablespace_Name
FROM TOAD_FILESTAT fs, DBA_DATA_FILES df
WHERE df.File_ID = fs.File_ID
ORDER BY TABLESPACE_NAME, FILE_ID
Error: ORA-00933: SQL command not properly ended

Perhaps the cause of the problem?

Best Regards,

Brian Keegan

Oracle DBA

Bristol West/Farmers Insurance Group

2

Yup. It is already fixed in beta, and will be fixed in a patch to Toad 12 soon.

From: Brian Keegan [mailto:bounce-briankeegan@toadworld.com]

Sent: Thursday, July 18, 2013 2:49 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Possible bug in Commercial 12.0.0.61 Tablespace Space History

Hi all,

In the new version when I go to Database\Administer\Tablespaces\Space History unless I check the By Datafile check box the graph doesn’t display anything.

When I spool the output and refresh the page is see this error in the Output scroll:

Session: @

Timestamp: 15:07:46.595

SELECT Tablespace, MDate, Sum(UsedSpace) Used

FROM TOAD_SPACE_HIST

GROUP BY Tablespace, MDate

SELECT UNIQUE fs.File_ID, Tablespace_Name

FROM TOAD_FILESTAT fs, DBA_DATA_FILES df

WHERE df.File_ID = fs.File_ID

ORDER BY TABLESPACE_NAME, FILE_ID

Error: ORA-00933: SQL command not properly ended

Perhaps the cause of the problem?

Best Regards,

Brian Keegan

Oracle DBA

Bristol West/Farmers Insurance Group

3

Thanks John,

Hope this wasn’t a duplicate question. I’m not so good at keeping up as I was when we had the email group. I just subscribed to the email journal to see if that helps me stay in touch.

–Brian

4

It was, but no problem.

From: Brian Keegan [mailto:bounce-briankeegan@toadworld.com]

Sent: Thursday, July 18, 2013 3:10 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Possible bug in Commercial 12.0.0.61 Tablespace Space History

Thanks John,

Hope this wasn’t a duplicate question. I’m not so good at keeping up as I was when we had the email group. I just subscribed to the email journal to see if that helps me stay in touch.

–Brian