My Oracle Support Banner

APEXExport Using -instance option gives ORA-00942 Error (Doc ID 2277276.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Application Express (formerly HTML DB) - Version 4.2.3 and later
Information in this document applies to any platform.


Apex 4.2.3
Oracle Solaris
DB 11gR2

When running APEXExport Using -instance option, APEXExport fails with an ORA-00942 error.

The steps to reproduce are:

 > cd /u01/dapex/dapexdb/11.2.0/apex/utilities/oracle/apex
 > export JAVA_HOME=$ORACLE_HOME/jdk
 > export PATH=$ORACLE_HOME/jdk/bin:$PATH
 > export CLASSPATH=$ORACLE_HOME/oui/jlib/classes12.jar:$ORACLE_HOME/apex/utilities
> java oracle.apex.APEXExport -db host:1521:sid -user sys -password xxxx -instance



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.