| **Navigation:**  SQL Drivers > Oracle >====== Oracle Accelerator Table Import Wizard--Login Dialog ====== | [[registering the oracle accelerator.htm|{{btn_prev_n.gif|Previous page}}]][[coming future.htm|{{btn_home_n.gif|Return to chapter overview}}]][[oracle accelerator table import wizard import list dialog.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

Clarion's Dictionary Editor Import Wizard lets you import Oracle table definitions into your Clarion Data Dictionary. When you select the Oracle Accelerator from the driver drop-down list, the Import Wizard opens the **Login/Connection **dialog. The **Login/Connection **dialog collects the connection information for the Oracle database.

**Notes:**

**1.****Before you can connect to the SQL database and import table definitions, the database must be started and must be accessible from your computer.**

**2.****Only those indexes directly associated with the table as CONSTRAINTs are imported by the Oracle Accelerator driver. If you need more indexes, simply define them manually.**

**3.****If the Oracle database INDEX flag is set to OFF, the Oracle Accelerator Import Wizard does not import CONSTRAINTS.**

Fill in the following fields in the **Login/Connection **dialog:

| **Host** | Select the Oracle host that contains the tables or views to import. If the **Host **list is empty, you may type in the host (a blank host specifies the Oracle 8 Personal database). See your DBA or network administrator for information on how the host is specified. For example, type //2: //to connect to the local Personal Oracle (7.2 and earlier) database. //X:// prefixes an IPX host and //TNS:// prefixes a TCP/IP host. **For Personal Oracle 8, leave the Host field blank.** |
| **Username** | Type your Oracle Username. See your server documentation or your DBA for information on applicable Usernames. |
| **Password** | Type your Oracle Password. See your server documentation or your DBA for information on applicable Passwords. |

Optionally, you type a complete connect string in the **Username **field using either of the following syntaxes:

**username/password@Protocol:dbname**

or

**username@Protocol:dbname,password**

For example, type:

**scott/tiger@2:production1**

in the **Username **field. Or, you may type just your username and the database name in the **Username **field, and type your password in the **Password **field.

For example, type:

**scott@2:production1**

in the **Username **field, then type

**tiger**

in the **Password **field. The Import Wizard displays the password as a series of asterisks. See your Oracle documentation for more information on Oracle connect string syntax.

| **Filter** | Optionally, provide a filter expression to limit the list of tables and views to import. The filter expression queries the ALL_CATALOG view. For example the filter: OWNER='SCOTT' returns only the tables which have SCOTT as the OWNER. . The filter expression is limited to 1024 characters in length. |

{{tipbox.jpg|TipBox.jpg}}

**The filter is case sensitive, so type your filter value accordingly.**

Following is a list of the ALL_CATALOG column names (and their Clarion datatypes) you can reference in your filter expression. See your Oracle documentation for more in formation on these columns.

| OWNER | CSTRING(31) |
| TABLE_NAME | CSTRING(31) |
| TABLE_TYPE | CSTRING(12) |

| **Next >** | Press this button to open the Import Wizard's **Import List **dialog. |