My Oracle Support Banner

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

Last updated on FEBRUARY 18, 2021

Applies to:

Oracle Application Express (APEX) - Version 4.2.3 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A 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 <DIR>/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

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

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

In this Document
Symptoms
Cause
Solution
References


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