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:Oracle Database - Enterprise Edition - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
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:
$ 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
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