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 (
)
-
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 (
)
-
Click to move all items from the selected list to the list of
available items.
-
Remove (
)
-
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 (
)
-
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.
Related topics
Table Definitions
Creating New Offline Database Definitions
Editing Offline Database Definitions
Working with Offline Database Definitions
Copyright © 1997, 2004, Oracle.
All rights reserved.