Skip to Content

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

Update statistics getting failed

Hi All,

I am getting an error while updating the statistics  as below.

BR0301E SQL error -20003 in thread 4 at location stats_tab_collect-69, SQL statement:

'EXECUTE stmt_1d'

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"ACCTIT"', ESTIMATE_PERCENT => 10, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASC

ADE => TRUE, NO_INVALIDATE => FALSE); END;'

ORA-20003: Specified bug number (9196440) does not exist

ORA-06512: at "SYS.DBMS_STATS", line 15223

ORA-06512: at "SYS.DBMS_STATS", line 15245

ORA-06512: at line 1

BR0886E Collecting statistics failed for table SAPSR3.ACCTIT

I have gone through Note and tried to relink all. But still problem persists.

1667086 - ORA-20003 - Specified bug number (<number>) does not exist.

I also found no Mopatch/Opatch directories  under oracle home. I have restored them from one of my backup.

Do I need to run again below scripts .

@?/rdbms/admin/dbmsstat.sql

  @?/rdbms/admin/prvtstas.plb

  @?/rdbms/admin/prvtstat.plb

Tags:
replied

Dear All,

My issue is resolved  guess update statistics is going on smooth now.

Just I have run the below scripts in startup restrict mode. This worked out for me. Thank you Rishi& Ashish for your quick response and suggestions.

@?/rdbms/admin/dbmsstat.sql

  @?/rdbms/admin/prvtstas.plb

  @?/rdbms/admin/prvtstat.plb

Thank you.

Regard's

Sai

0 View this answer in context

Helpful Answer

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