Ittichai at 01:42, 4 February 2012

2012-02-04T01:42:44Z

Ittichai: Created page with "== 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...."

2012-02-04T01:42:24Z

Created page with "== 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...."

New page

== 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.
<pre>
SQL> conn scott/tiger
SQL> col WORKSPACE_ID format 999999999999999999
SQL> select WORKSPACE_ID from APEX_WORKSPACES;
WORKSPACE_ID
-------------------
6107132214640705
</pre>

* The APEXExport syntax
<pre>
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
</pre>
* Sample of script
<pre>
# 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)))

</pre>

← Older revision		Revision as of 01:42, 4 February 2012
Line 49:		Line 49:

	</pre>		</pre>
		+
		+	[[Category:APEX]]

APEX application export utility - Revision history

Ittichai at 01:42, 4 February 2012

Ittichai: Created page with "== 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...."