Expdp for USER DDL, Get ORA-39165: Schema Was Not Found. ORA-39168: Object Path USER Was Not Found
(Doc ID 2575404.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
Export parameter file used and the error log
USERID=system/pwd
DUMPFILE=expdp_schemas.dmp
DIRECTORY=DATA_PUMP_DIR
SCHEMAS=schema1
INCLUDE=user =====> We are interested in extracting the user DDL
ORA-39165: Schema SCHEMA1 was not found.
ORA-39168: Object path SCHEMA_EXPORT/USER was not found. >>>>>>>>>>>>>>>>>> Error
ORA-31655: no data or metadata objects selected for job
Changes
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 |
Changes |
Cause |
Solution |
References |