My Oracle Support Banner

Datapump Export failed with ORA-31693 ORA-02354 ORA-39826 (Doc ID 2714700.1)

Last updated on MAY 18, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information 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


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