My Oracle Support Banner

ORA-39166 ORA-39126 ORA-942 EXPDP when Using Mixed Case with VIEWS_AS_TABLES (Doc ID 2919719.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

DataPump export (EXPDP)  of a view as a table which has a mixed-case name fails with errors ORA-39166 or ORA-39126 and ORA-00942:

File exp.par:

TABLES='Test2'
VIEWS_AS_TABLES='Test'

$ expdp ... parfile=exp.par

ORA-39166: Object <SCHEMA>.TEST2 was not found or could not be exported or imported.
ORA-39166: Object <SCHEMA>.TEST was not found or could not be exported or imported.
ORA-31655: no data or metadata objects selected for job

-- OR --

When enabling SQL tracing, we see errors ORA-39126 and ORA-00942

expdp ... tables='\"Test2\"' views_as_tables='\"Test\"'
...
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-00942: table or view does not exist

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.