quarta-feira, 5 de setembro de 2012

ORA-01502: index 'BIMINFIN.PK_FAT_0_ORCAMENTO' or partition of such index is in unusable state

ORA-01502: index 'BIMINFIN.PK_FAT_0_ORCAMENTO' or partition of such index is in unusable state AFTER TRUNCATE PARTITIONED TABLE:

add: UPDATE GLOBAL INDEXES

Ex: ALTER TABLE my_table TRUNCATE PARTITION partition UPDATE GLOBAL INDEXES;





0 comentários: