6 Replies Latest reply on May 25, 2020 10:12 AM by 4257543

    Exporting APEX cloud application from remote machine


      Hi All,


      I am working on implementing continuous integration for Oracle APEX clound application. I want to export and then import application using command line. I did some research and found that this can be done using APEXEXPORT command.



      APEX cloud


      Build Environment:

      Windows 10 Pro

      SQLcl is installed

      APEXExport is downloaded and available on VM

      ojdbc8.jar downloaded from https://www.oracle.com/database/technologies/jdbc-ucp-122-downloads.html

      Environment Variables set as follows:

      sqlcl : C:\Setup\sqlcl\bin

      APEX_BASE: C:\Setup\apex_20.1_en\apex

      ojdbc8.jar: C\Setup\.\ojdbc8.jar



      I tried APEXExport from utilities folder

      java oracle.apex.APEXExport -db <apex cloud domain>:1521:xe -user "username" -password "password" -applicationid 001 -expOriginalIds


      But i am getting an error "

      Exception in thread "exception in thread "main" java.lang.NoClassDefFoundError: oracle/jdbc/OracleDriver"


      I want to know following:

      1. Is it possible to export APEX cloud application from remote machine?
      2. if yes what will be ( i am new to Oracle hence i am not sure about these values )
        • hostname: www.apex.com or host name from url that i used to log in to apex application?
        • service name: where can i find this information
      3. What could be the reason for above error? any pointers to resolve this?
      4. How sqlcl can be used to export application? if this is possible can you give connection command to apex server?


      Any help is greatly appreciated.