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 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [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.
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 |