PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

DDDAudit question regarding index-1

edited Jul 7, 2017 6:14PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 6 commentsAnswered

We are facing index inconsistency issue on few tables.

Example: table PO_POA_HDR_HIST has 3 index count on psrecdefn table, 3 indexid in pskeydefn table, 3 entries in psindesxdefn table.

when i rebuild the index(app designer) for table PO_POA_HDR_HIST. its drop only 2 index & creating on 2 index. So i manually drop the 3rd index which is not created by tools.

So, currently table PO_POA_HDR_HIST has 2 index count on psrecdefn table, 2 indexid in pskeydefn table, 2 entries in psindesxdefn table. (in dev environment )

while working on migration plan, we took the script & executed on QA environment.

so, the script is dropping the 3 index & creating 2 index

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