Command line export utility

A hidden utility in APEX is a Java program that is provided with the APEX installation files, and can be used to export APEX applications via the command line. This enables us to export applications without needing to log into the APEX Web interface. Being accessible from the command line means we could automate the export of applications on a regular basis for backups.

The export utility is named APEXExport.class and can be found in the utilities directory of the APEX installation files.

To use the export utility, we need to ensure that a JDK version 1.4 or higher is used and the Oracle JDBC libraries are in your CLASSPATH. To set the CLASSPATH in a Windows environment, we would use the following command:

Set CLASSPATH=%CLASSPATH%;.\;%ORACLE_HOME%\jdbc\lib\classes12.jar

We can then run the export utility by issuing the following command from the APEX utilities directory:

java oracle.apex.APEXExport -db -user -password -applicationid -workspaceid -instance - skipExportDate...