Datapump Export failed with ORA-31693 ORA-02354 ORA-39826
(Doc ID 2714700.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
Oracle ver -->11.2.0.4
OS ver -->Linux x86-64
====================
Below errors reported
ORA-31693: Table data object "USER"."CMP4$xxxxxx" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-39826: Direct path load of view or synonym (USER.CMP4$xxxxxx) could not be resolved.
Tables with names like CMP3$xxxxxx or CMP4$xxxxxx (where xxxxxx is a number) creates during Compression Advisor and dropped after the Compression Advisor. If you see Tables with names like CMP3$xxxxxx or CMP4$xxxxxx (where xxxxxx is a number) left over after running Compression Advisor, it is likely because Compression Advisor failed at some point. These are interim tables created/used by Compression Advisor, which are normally dropped when it completes. You can safely drop those tables.
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 |