Monday, February 24, 2014

ORA-28604: TABLE TOO FRAGMENTED TO BUILD BITMAP INDEX

ORA-28604: TABLE TOO FRAGMENTED TO BUILD BITMAP INDEX

GREAT SOLUTION FOR BITMAP INDEX BUILD ERROR - ORA-28604

TRY THIS COMMAND:

ALTER TABLE &TABLE_NAME MINIMIZE RECORDS_PER_BLOCK;

No comments:

Post a Comment

ADF functions

 toString(JT_DEAL_PLAN_EFF_DT, 'MM/dd/yyyy HH:mm:ss','es-ES')