Editing Views

Edit online database views and offline and modeled views from the Edit View dialog, or the Edit Offline View dialog.

To edit an online view:

1. Select View Connection Navigator.
2. Expand Database and select a database connection.
3. In the connection, expand a schema.
4. In the schema, expand Views.
5. Right-click a view name and select Edit, or double-click the view name.
6. The Edit View dialog opens.

To edit an offline view:

1. In the navigator, expand the workspace, project, and schema.
2. Right-click the offline view and choose P roperties.
   Or
   Double-click the offline view.
3. The Edit Offline View dialog opens.

To edit an offline view:

1. In the navigator, expand the workspace, project, and schema.
2. Right-click the offline view and choose P roperties.
   Or
   Double-click the offline view.
3. The Edit Offline View dialog opens.

In the Edit View dialog or the Edit Offline View dialog, select an information category on the left and change the values in that category on the right. Any items that are grayed out cannot be selected or changed.

Related topics

Creating, Editing, and Dropping Schema Objects

Copyright © 1997, 2004, Oracle. All rights reserved.