Help Center/ GaussDB(DWS)/ Best Practices/ Data Migration/ Migrating Data From Oracle to GaussDB(DWS)/ Migrating Table Definitions/ Installing the PL/SQL Developer on the Local Host
Updated on 2024-03-13 GMT+08:00
View PDF

Installing the PL/SQL Developer on the Local Host

Procedure

  1. Decompress the PL/SQL Developer, Instant Client, and DSC packages.
  2. Configure an Oracle home and OCL library for PL/SQL Developer.

    The following uses the PL/SQL Developer Trial Version as an example.

    1. On the login page, click Cancel.

    2. Choose Configure > Preferences > Connection, and add the Oracle Home and OCl library configurations.
    3. Copy the instantclient path obtained from 1 (for example, D:\Oracle\instantclient_19_17\oci.dll) to the home directory of the Oracle database.

      Copy the oci.dll file path (for example, D:\Oracle\instantclient_19_17\oci.dll) in the instantclient file to the OCI library.

  1. Go back to the PL/SQL Developer login page. Enter the username, password, and database address, for example, xx.xx.xx.xx:1521/ORCL.

  2. Click OK. If the database is connected, it indicates that the PL/SQL Developer is installed successfully.