Unable to view object type OPERATOR in the Schema Browser (4310290)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Unable to view object type OPERATOR in the Schema Browser
Description

I am unable to view objects in the Schema Browser that are object type OPERATOR. There is no tab for this object type
Resolution

WORKAROUND
none
STATUS
Enhancement request TOR-5195 has been submitted to Development for consideration in a future release of Toad for Oracle
Defect ID

TOR-5195
Additional Information

The jira includes to add Support for Operators and IndexTypes to Generate Schema Script and Export DDL.
Query to know the customer operators:

SELECT *
FROM all_objects
WHERE object_type = 'OPERATOR'
AND oracle_maintained = 'N' -- see note below. Add this condition to see the operators created by you and not Oracle
ORDER BY object_name

Note: oracle_maintained denotes whether the object was created, and is maintained, by Oracle-supplied scripts (such as catalog.sql or catproc.sql).

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title