Unable to run statspack report on a selected snapshot pair when using Direct as connection method (4334674)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Unable to run statspack report on a selected snapshot pair when using Direct as connection method
Description

Unable to run statspack report on a selected snapshot pair when using Direct as connection method.

The error is :

Cannot create file "C:\Users\XXXXe\AppData\Roaming\Dell\Toad for Oracle\12.6\User Files\StatsPack Reports\11gR2\Run_VHQCD41:15213\HPRD7_92208_92224.sql". "The syntax of the filename or directory name or volume is incorrect.
Cause

The pathame generated by Toad for Oracle is "Run_VHQFD41:15211", which is automatically derived from the "direct path" connection string.
That path contains a " : " which is an illegal character for Windows path and file names.
Resolution

WORKAROUND
Select TNS as connection method
STATUS
Waiting for fix in a future release of Toad for Oracle
Defect ID

117405

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title