APEX application export utility

APEX Application Export Utility
SQL> conn scott/tiger SQL> col WORKSPACE_ID format 999999999999999999 SQL> select WORKSPACE_ID from APEX_WORKSPACES; WORKSPACE_ID ---  6107132214640705
 * 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.

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
 * The APEXExport syntax

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 export APEX_UTIL_HOME=/opt/oracle/product/11.1.0/apex/utilities
 * Sample of script
 * 1) Export the location of the APEX utility scripts
 * 2) Use the scripts from the APEX download with same version of the APEX installation.
 * 3) If not, some java run errors may be experienced.

export CLASSPATH=.:${ORACLE_HOME}/jdbc/lib/ojdbc5.jar
 * 1) Export the CLASSPATH
 * 2) export CLASSPATH=.:${ORACLE_HOME}/jdbc/lib/ojdbc6.jar

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

${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)))