Import as part of upgrade changing index names

  • From: Michael Schmitt <mschmitt@xxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 8 May 2015 15:25:57 +0000

Hello,

I am using datapump to move a database from 11.1.0.7 to 11.2.0.4. I noticed
after our test migration that 217 (of 400) indexes under a specific schema have
a slightly different name.

The names that are changing all have some specific numbering in back. Example
below. Any ideas?

Source 11.1.0.7:
ODS_ALIGNED_SOG_1I1
ODS_ALIGNED_SOG_1I10
ODS_ALIGNED_SOG_1I11
ODS_ALIGNED_SOG_1I12
ODS_ALIGNED_SOG_1I15
ODS_ALIGNED_SOG_1I27
ODS_ALIGNED_SOG_1I30
ODS_ALIGNED_SOG_1I5
ODS_ALIGNED_SOG_1I6
ODS_ALIGNED_SOG_1I7
ODS_ALIGNED_SOG_1I8

Target 11.2.0.4:
ODS_ALIGNED_SOG_2I1
ODS_ALIGNED_SOG_2I10
ODS_ALIGNED_SOG_2I11
ODS_ALIGNED_SOG_2I12
ODS_ALIGNED_SOG_2I15
ODS_ALIGNED_SOG_2I27
ODS_ALIGNED_SOG_2I30
ODS_ALIGNED_SOG_2I5
ODS_ALIGNED_SOG_2I6
ODS_ALIGNED_SOG_2I7
ODS_ALIGNED_SOG_2I8

Thanks in advance

Other related posts:

  • » Import as part of upgrade changing index names - Michael Schmitt
  1. Home
  2. oracle-l
  3. Archive
  4. 05-2015