Object Search, ORA-01795: maximum number of expressions in a list is 1000
When doing an Object search, I select over 1000 users from the Schemas to search column. I use the Select All function to select all of the users. At the last moment, deselect one user. I select TABLE from the Search column names. I input a term in the search Term field. I click on the green execute triangle to execute the Object Search.
The following error is generated:
ORA-01795: maximum number of expressions in a list is 1000
WORKAROUND:
Select ALL schemas and manually avoid the single unselected schema if any objects are returned.
STATUS:
Waiting for fix in a future version of Toad for Oracle.
