Database update statistic failed during Export phase
NW2004s system with Oracle 10G on windows 2003 server and clustered enviornment.
During System copy ,when it is checking uodated statistic ,it is giving the follwoing error.
BR0301E SQL error -20000 in thread 4 at location stats_tab_collect-20, SQL statement:
'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPDAT"', TABNAME => '"/BIC/FZPCA_CLI"', ESTIMATE_PERCENT => 10, METHOD_OPT => 'FOR COLUMNS SIZE 225 "KEY_ZPCA_CLIP" FOR COLUMN
ORA-20000: index "SAPDAT"."/BIC/FZPCA_CLI~010" or partition of such index is in unusable state
ORA-06512: at "SYS.DBMS_STATS", line 13159
ORA-06512: at "SYS.DBMS_STATS", line 13179
ORA-06512: at line 1
BR0886E Checking/collecting statistics failed for table SAPDAT./BIC/FZPCA_CLI