ORA-942 or ORA-6502 / ORA-22275 When Importing Applications or Workspaces in APEX

(Doc ID 1333062.1)

Last updated on FEBRUARY 07, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 1.6 and later
Information in this document applies to any platform.
***Checked for relevance on 09-Dec-2012***

Symptoms

When trying to import an APEX application or APEX workspace the following error is seen in the browser:

ORA-00942: table or view does not exist

DAD name: apex_uat
PROCEDURE : wwv_flow.accept
URL : http://s6320bl03:7777/pls/apex_uat/wwv_flow.accept

ENVIRONMENT:
============
PLSQL_GATEWAY=WebDb
GATEWAY_IVERSION=2
SERVER_SOFTWARE=Oracle-Application-Server-10g/10.1.2.2.0 Oracle-HTTP-Server
GATEWAY_INTERFACE=CGI/1.1

 

OR

 

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