My Oracle Support Banner

A Renamed Index Was Created With Different Name After Import (Doc ID 2512751.1)

Last updated on MAY 12, 2020

Applies to:

Oracle Database - Standard Edition - Version to [Release 12.1 to 12.2]
Oracle Database - Enterprise Edition - Version to [Release 12.1 to 12.2]
Information in this document applies to any platform.
NOTE: In the images and/or the document content below, the user information and data used represents fictitious data.
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


If you do not explicitly describe an index name during "CREATE TABLE" command, an index is created with the auto-generated name.
After changing this index with the "ALTER INDEX RENAME" command, export with the expdp utility and import it into another environment, the name of the index will be changed.


The index name was changed using "ALTER INDEX .. RENAME" command.


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.