My Oracle Support Banner

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

Last updated on OCTOBER 11, 2019

Applies to:

Oracle Database - Standard Edition - Version 12.2.0.1 and later
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.

Symptoms

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.

Changes

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

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.