My Oracle Support Banner

ORA-942 or ORA-6502 / ORA-22275 When Importing Applications or Workspaces in APEX (Doc ID 1333062.1)

Last updated on AUGUST 02, 2019

Applies to:

Oracle Application Express (APEX) - Version 1.6 and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 02-Aug-2019***

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://<HOST>:<PORT>/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

 

Changes

 

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
Changes
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.