Oracle Application Express Command-line Export Utilities
--------------------------------------------------------


Definition of Each file
------------------------------------
  readme.txt       		     - This file
  APEXExport.class           - Java program used to export Oracle Application Express applications
  APEXExportSplitter.class   - Java program used to split Oracle Application Express export files into
                               separate SQL scripts


APEXExport Usage Instructions
-----------------------------
The program APEXExport can be used to export Oracle Application Express applications
from the command-line, without requiring a manual export from the Web interface of
Oracle Application Express.

1) To use APEXExport, a JDK of version 1.5 or greater must be used.  Additionally, the Oracle JDBC
class libraries must be in your CLASSPATH.

To set the CLASSPATH, following are some examples:

export CLASSPATH=.:${ORACLE_HOME}/jdbc/lib/classes12.zip

...from the Bash shell or ...

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

...from Windows environments.

2) From the apex/utilities directory, issue the command:

   java oracle.apex.APEXExport


...returns the following output with both usage directions and examples.

Usage APEXExport -db  -user  -password  -applicationid  -workspaceid -instance -skipExportDate -expSavedReports -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
    -expSavedReports: Export all user saved interactive reports

    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
    Instance Example:
       APEXExport -db candy.us.oracle.com:1521:ORCL -user apex_030200 -password apex -instance



Note: To export applications from the entire instance, the database user account APEX_030200 will
need to be unlocked.  The account should then be locked after the desired export is performed.




APEXExportSplitter Usage Instructions
-------------------------------------
The program APEXExportSplitter can be used used to split Oracle Application Express export files
into separate SQL scripts.  This is useful for management of files corresponding to
the discrete elements of an Application Express application.


1) To use APEXExportSplitter, a JDK of version 1.5 or greater must be used.

To set the CLASSPATH, following are some examples:

export CLASSPATH=.:$CLASSPATH

...from the Bash shell or ...

set CLASSPATH=%CLASSPATH%;.\;

...from Windows environments.


2) From the apex/utilities directory, issue the command:

   java oracle.apex.APEXExportSplitter


...returns the following output with usage directions.

Usage java oracle.apex.APEXExportSplitter filename
-help       : < print this syntax >
-flat       : < flat file structure >
-debug      : < print debug info >
-update     : < create update file >
-nochecksum : < don't check for changes >




3) To split an application export file (f123.sql in this example) creating sub directories for
   each component type, issue this command:

       java oracle.apex.APEXExportSplitter f123.sql

4) To split an application export file (f123.sql in this example) containing the component type
   in the file name (not creating any directories), issue this command:

       java oracle.apex.APEXExportSplitter f123.sql -flat