My Oracle Support Banner

DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS Generates Duplicate Index Names on Interim Table (Doc ID 1922809.1)

Last updated on JULY 29, 2021

Applies to:

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


Source table has multiple indexes with very long names like "index_with_very_long_nm", "index_with_very_long_nm1", "index_with_very_long_nm2" that reside in more than one schema.

When trying to reorg such table with online DBMS_REDEFINITION, duplicate names are getting generated for some of the indexes on the interim table.  Due to this, the desired number of indexes were not created.

For example:

For above two indexes (nm1, nm2), DBMS_REDEFINITION creates only one index with the name "tmp$$_index_with_very_long_2". 


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

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