-
Title
Can Schema Browser Treeview display all Tables regardless of Schema? -
Description
I would like to be able to get a list of all tables in a database, no matter which schema owns them, in treeview in the schema browser.
-
Cause
This is not possible to currently do in the treeview.
-
Resolution
WORKAROUND #1:
Switch to the tabbed or dropdown schema browser view and click on the table filter (gray funnel) button in the toolbar on the left hand side of the schema browser. For “Schema Name”, select “All Schemas”.
WORKAROUND #2:
If you have SYS privileges, you can do this...
1) Go to SB - Treeview
2) Go to "My Schema" (if logged in as SYS), or "All Schemas" (if user has SYS privileges)
3) Select User "SYS"
4) Select Views
5) Select "ALL_TABLES"
6) Report shows on RHS -
Defect ID
IP141 -
Additional Information
Click on the following link to view the enhancement request at our Idea Pond website. While viewing it, you can vote on if you want it implemented or not.
Click Here