Import as part of upgrade changing index names

From: Michael Schmitt <mschmitt_at_uchicago.edu>
Date: Fri, 8 May 2015 15:25:57 +0000
Message-ID: <1184E7EFAB1D1C47A5038D06F64BE926316D3D1A_at_xm-mbx-09-prod.ad.uchicago.edu>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 08 2015 - 17:25:57 CEST

Original text of this message