This discussion is archived
3 Replies Latest reply: May 9, 2013 7:42 PM by Hussein Sawwan-Oracle RSS

indexing during upgrade

Walashkar Newbie
Currently Being Moderated
Dear All,

11.5.10.2 upgrade to r12.1.

We are facing 5 hours slowness in the script icxr12mi.sql and as per the note (Performance Issue With icxr12mi.sql When Applying R12.1.1 Maintenance Pack Patch 6678700 to Upgrade from 11.5.10.2 to R12.1.3 [ID 1366569.1]) . We need to create index on the table MTL_ITEM_BULKLOAD_RECS . How can I stop adpatch and create the index and start adpatch to continue from the same place of the script icxr12mi.sql .

Please advise

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points