Help Center/ Data Warehouse Service / Best Practices/ Data Migration/ Using CDM to Migrate Oracle Data to a DWS Cluster/ Migrating Table Definition/ Installing the PL/SQL Developer on the Local Host
Updated on 2025-04-09 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.

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