To import an existing Oracle database table

  1. Click the Import button in the CONNX Data Dictionary Manager window.

  2. The Import CDD dialog box appears. Select Oracle database from the Import Type list box.

  3. Type the SQLNet database name in the Enter the SQLNet connect name text box.   

    image\UserRef_10.jpg

  4. Select the Include System Tables check box to import system table definitions into the CDD.

  5. Select the Get Statistics check box to identify the table sizes.

  6. Type a user name, and password under Logon Information.

  1. UserName: OpenVMS user name used to log in to the account where the database resides.

  2. Password: OpenVMS password used to log in to the account where the database resides.

  1. Click the OK button. The CONNX Import Table Selection dialog box appears with a list of available table names. Click the Add or Add All button to move the tables to the Select Tables for Import pane.

    Orac_01.jpg
     

  2. Click the OK button to import the selected tables into CONNX. The Oracle database tables are added to the list of accessible objects in the CONNX Data Dictionary Manager window.

Related Topic

CHICLET.JPG Importing Oracle Database Tables