Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Not what you were looking for? View more on this topic or Ask a question