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

Last updated on JUNE 19, 2017

Applies to:

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

Symptoms

ENVIRONMENT:
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

 

Cause

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 hundreds of Community platforms