Demantra Solutions - EBS (MOSC)

MOSC Banner

Is it an expected behavior that after reorg SALES DATA index is changed?

edited Oct 25, 2017 5:00AM in Demantra Solutions - EBS (MOSC) 1 commentAnswered

We have recently performed reorg.

By below query we determined the reorg factor:

SELECT ui.index_name,trunc((ut.num_rows/ui.clustering_factor)/(ut.num_rows/ut.blocks),2)

FROM user_indexes ui, user_tables ut, user_constraints uc

WHERE ui.table_name=ut.table_name

AND ut.table_name=uc.table_name

AND ui.index_name=uc.index_name

AND UC.CONSTRAINT_TYPE='P'

AND ut.table_name=upper('SALES_DATA');

The query used to return "SALES_DATA_PK" as "index_name before reorg. Now, it shows "SALES_DATA_QTY_FORM_121_FI". Is it an expected behavior. anyone can help explaining why the index name has changed after reorg?

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

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center