Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\utilities\readme.txt
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
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de