Data Connections Options Page

The Data Connections Options page allows you to customize Server Explorer by choosing which Oracle database schema object types will be displayed for an ODT connection. This may be helpful in improving performance of Server Explorer or in cases where you are getting permissions related errors for certain types of objects.

Changes made to these displayed database object types will not affect any already existing connections even after doing a refresh. To change the displayed object types for already created connections, use the Filters Tab on the Connection Dialog instead.

This page also allows you to limit the number of objects that can appear under Server Explorer collection nodes (Tables, Views, Procedures, Functions, and so on). If the number of objects exceeds the chosen maximum value, a message box appears to alert you that not all objects were displayed. This can improve performance and prevent hangs in the case of schemas that have a large number of objects

Description of serverexploreroptions.gif follows

Description of the illustration serverexploreroptions.gif

Select OK to save and apply the changes and Cancel to drop the changes.

Using the Data Connections Options Settings

Control	Description
Display the following object types for a connection	Each object type that is selected will appear in the Server Explorer. The others do not. Changes made to the displayed database objects will not affect any already existing connections even after doing a refresh. To change the displayed objects for already created connections, use the Filters Tab on the Connection Dialog instead.
Select All	Selects every object type.
Clear All	Deselects every object type.
Maximum number of database objects to display per database object type	This value limits the number of objects that can appear under Server Explorer collection nodes (Tables, Views, Procedures, Functions, and so on). If the number of objects exceeds the chosen maximum value, a message box appears to alert you that not all objects were displayed. This can improve performance and prevent hangs in the case of schemas that have a large number of objects.