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 APRIL 01, 2023
Applies to:
Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]Information in this document applies to any platform.
Symptoms
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
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 |