Technology Stack - EBS (MOSC)

MOSC Banner

Index mismatch when partitioning WF tables in 12.24 with wfpart.sql

edited Oct 8, 2016 5:00AM in Technology Stack - EBS (MOSC) 2 commentsAnswered

Hi,

I plan to partition Workflow tables on my 12.2.4 instance.

Scripts version are the following:

wfpart.sql:Rem $Header: wfpart.sql 120.4.12020000.2 2012/07/19 22:01:13 alsosa ship $

wfpartb.pls:/* $Header: wfpartb.pls 120.7 2009/03/02 14:45:18 alsosa ship $ */

wfparts.pls:/* $Header: wfparts.pls 120.4 2006/03/26 22:07:55 rtodi noship $ */

I've generated the wfpart.sql script but there is some differences between indexes on partitioned tables and indexes on the original tables. For some of them i've found bugs and MOS notes to correct it but for the others i dunno if it's bug or if it's an index update because of the partitioning key. here is all the differences i got:

WF_ITEM_ACTIVITY_STATUSES

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center