APEX application export utility

APEX Application Export Utility

• To use APEXExport, a JDK of version 1.4 or greater must be used. Additionally, the Oracle JDBC class libraries must be in your CLASSPATH.
• Find out the workspace ID if needed.

SQL> conn scott/tiger
SQL> col WORKSPACE_ID format 999999999999999999
SQL> select WORKSPACE_ID from APEX_WORKSPACES;
       WORKSPACE_ID
-------------------
   6107132214640705

• The APEXExport syntax

Usage APEXExport -db  -user  -password  -applicationid  -workspaceid -instance -skipExportDate -debug
    -db:              Database connect url in JDBC format
    -user:            Database username
    -password :       Database password
    -applicationid :  ID for application to be exported
    -workspaceid :    Workspace ID for which all applications to be exported
    -instance :       Export all applications
    -skipExportDate : Exclude export date from application export files

    Application Example:
       APEXExport -db candy.us.oracle.com:1521:ORCL -user scott -password tiger -applicationid 31500
    Workspace  Example:
       APEXExport -db candy.us.oracle.com:1521:ORCL -user scott -password tiger -workspaceid 9999

• Sample of script

# Export the location of the APEX utility scripts
# Use the scripts from the APEX download with same version of the APEX installation.
# If not, some java run errors may be experienced.
export APEX_UTIL_HOME=/opt/oracle/product/11.1.0/apex/utilities

# Export the CLASSPATH
#export CLASSPATH=.:${ORACLE_HOME}/jdbc/lib/ojdbc6.jar
export CLASSPATH=.:${ORACLE_HOME}/jdbc/lib/ojdbc5.jar

# Perform exports
cd ${APEX_UTIL_HOME}
java oracle/apex/APEXExport -db ${DBHOST} -user ${USR} -password ${PASSW} -workspaceid ${WKID} 

${DBHOST} for standalone
HOST1:1521:ORA11G

${DBHOST} for RAC (sample of two nodes)
(description=(address_list=(address=(host=HOST1)(protocol=TCP)(port=1521))(address=(host=HOST2)(protocol=tcp)(port=1521)))(connect_data=(service_name=ORA11G)))