Environment Preferences

The Environment category enables you to set generic preferences that control the client environment such as displaying welcome pages for wizards and recycle bin preferences.

You can set the following environment preferences:

• Recycle Deleted Objects: Select this option to move deleted objects to the recycle bin. If this option is not selected, any objects you delete are lost and you have no way of recovering them.

• Allow Optimize Repository Warning on Startup: Select this option to collect schema statistics when you log in to OWB. Collecting schema statistics improves repository performance. If this option is selected, at log on, OWB determines if statistics must be gathered for the repository schema. If statistics must be gathered, a warning dialog box is displayed asking if you want to gather statistics now. Click Yes to collect schema statistics and optimize the repository.

  If you do not select this option, you can still collect schema statistics from the Design Center by selecting Optimize Repository from Tools menu.

• Show Delete Confirmation Dialog Box: Select this option to display a dialog box that asks for a confirmation before deleting an object. When this option is selected, if you delete an object, the OWB Warning dialog box is displayed. Click Yes to delete the object. Click No to cancel the Delete operation and retain the object.

• Hide All Wizard Welcome pages: Select this option to hide the welcome page of all wizards. Every wizard in OWB starts with a Welcome page that summarizes the steps to follow to complete that task. To display the Welcome page for all wizards, deselect this preference.

• Empty Recycle Bin on Exit: Select this option to empty the contents of the recycle bin when you exit the OWB client. Deselect this option to save the recycle bin objects across sessions.

• Default Workspace: Select this option to set the default workspace for the logged in user to use. A drop-down list shows the workspaces for which the logged in user is registered. The initial setting is for the first workspace that you own or for which you were registered.

  
  

  Note: You can access public views from your default workspace. From your default workspace, when you log in to SQL*Plus, you can access public views (design-time public views or runtime public views) without needing to call a separate procedure. If you try to access public views from any workspace other than the default, then you must call: WB_workspace_management.set_workspace(<wksp_name>, <wksp_owner>). If you want to switch to a workspace other than the default one, then you can call the WB_workspace_management.set_workspace procedure. You must have the ACCESS_PUBLICVIEW_BROWSER system privilege to retrieve useful information from the pubic views. Otherwise, you will get "0 rows returned." You may need to ask the workspace owner or workspace admin to grant the system privilege ACCESS_PUBLICVIEW_BROWSER.