My Oracle Support Banner

Datapump Import Fails With ORA-31685 on Indexes with DPBP 37470729 on 19.26 (Doc ID 3072552.1)

Last updated on FEBRUARY 28, 2025

Applies to:

Oracle Database - Enterprise Edition - Version 19.26.0.0.0 and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Datapump import as a non-SYSTEM user fails with ORA-31685 on indexes. Import log shows:

Changes

Issue is seen after patching the 19.26 Oracle Database with the Datapump Bundle Patch 37470729.

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

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