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 220.127.116.11 and later
Information in this document applies to any platform.
Oracle ver -->18.104.22.168
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.
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