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

Last updated on JANUARY 06, 2023

Applies to:

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

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