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,
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-lReceived on Fri May 08 2015 - 17:25:57 CEST