Import Offline Database Objects Wizard - Select Objects

Use to select the tables and views in a database schema to import as offline database objects.

Name Filter
(Optional) Enter characters to filter the list of available tables and views. For example, to display only objects with a name beginning with M, enter M. To display only objects with a name beginning with ME, enter ME.
Auto-Query
(Optional) Select this to automatically update the list of available tables and views as you enter characters in the Name Filter field. If you have a lot of available tables and views such that refreshing the list slows your machine, deselect this checkbox and use Query instead.
Schema
Lists names of the database schemas available from the connection you selected. Select the one you want.
Query
When Auto-Query is deselected, click this to update the list of tables and views available in the database schema, filtering by the characters entered in the Name Filter field.
Object Types
Select one or both object types.
Tables
Select this to display tables.
Views
Select this to display views.
Available
The list of tables and views available in the database schema you selected.
Selected
The tables and views selected for importing.
Copy (copy button )
Click to move highlighted items from the selected list to the list of available items. You can highlight more than one item by holding down the Ctrl key and clicking on each item.
Copy All (copy all button )
Click to move all items from the selected list to the list of available items.
Remove (remove button )
Click to move highlighted items from the list of available items to the selected list. You can highlight more than one item by holding down the Ctrl key and clicking on each item.
Remove All (remove all button )
Click to move all items from the list of available items to the selected list.
Object Name
You can import a database object with a new name. Select it in Selected, and enter the new name in this field.
Note: If you try to reconcile the renamed table back to the database, you will receive an error message because the database does not have a record of the table with its new name. To avoid this, generate the renamed table back to the database.

Table Definitions
Creating New Offline Database Definitions
Editing Offline Database Definitions
Working with Offline Database Definitions

 

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