Return
-
Title
Getting "ORA-00920: invalid relational operator" when launching Session Browser. -
Description
When launching session browser it automatically opens with the error "ORA-00920: invalid relational operator". The window cannot be opened. General connections seems ok and no other issue with other features in Toad. -
Cause
Corrupted session browser filter file. -
Resolution
With Toad closed, go to the Toad for Oracle application data directory:
C:\Users\<personal folder>\AppData\Roaming\Quest Software\Toad for Oracle\<version>\User Files (Win 7 or Vista)
or
C:\Documents and Settings\<personal folder>\Application Data\Quest Software\Toad for Oracle\<version>\User Files (XP)
rename/reset the TOAD_SESSBROWFILTERS.INI file. -
Additional Information
This applies to various version of Toad.