My Oracle Support Banner

EXPDP fails with ORA-39165: Schema was not found error when multiple INCLUDE clauses are used for an object type. (Doc ID 2686079.1)

Last updated on JUNE 30, 2020

Applies to:

Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.


Multiple INCLUDE clauses were used in parameter file for tables like in example below:

include=TABLE:"LIKE 'MIGR%'"
include=TABLE:"LIKE 'EGO%'"
include=TABLE:"LIKE 'EGP%'"
include=PACKAGE:"LIKE 'PKG%'"

EXPDP fails with following even though the user exists:

ORA-39165: Schema xxxx was not found.
ORA-31655: no data or metadata objects selected for job


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

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