Oracle Application Express (MOSC)

MOSC Banner

backup of apex failed

edited Mar 2, 2023 11:50AM in Oracle Application Express (MOSC) 1 commentAnswered

Dear Experts,

Database version 19c

ORDS version 21.2

Apex version 21.1

CDB prodcdb

PDB PRODDB

We are taking backup of workspaces but getting failed. Can you please help us

location where apex is extracted /u02/EMbook/apex
[oraprod@erpproddb1 utilities]$ pwd
/u02/EMbook/apex/utilities

[oraprod@erppdb1 utilities]$ export JAVA_HOME=$ORACLE_HOME/jdk

[oraprod@erpdb1 utilities]$ export PATH=$ORACLE_HOME/jdk/bin:$PATH

[oraprod@erpdb1 utilities]$  export CLASSPATH=.:$ORACLE_HOME/jdbc/lib/ojdbc8.jar:$ORACLE_HOME/apex/utilities/oracle/apex:$ORACLE_HOME/oui/jlib/classes12.jar
[oraprod@erpproddb1 utilities]$

 [oraprod@erpproddb1 utilities]$ java oracle.apex.APEXExport -db erpddb1:1528:PRODDB -user system -password listener#1 -expWorkspace

Exception in thread "main" java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist


        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
   

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center