Skip to Content
0
Former Member
Sep 11, 2009 at 09:16 PM

SQL error -20003 at location stats_tab_collect-20

468 Views

Hello All,

we are executing ths statistics with the followin command

brconnect -u / -c -f stats -t all -f collect

but the proccess report errors like:

BR0301E SQL error -20003 at location stats_tab_collect-20, SQL statement:

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BEV3/CHCMVWPRO"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'

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

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

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

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for table SAPSR3./BEV3/CHCMVWPRO

BR0301E SQL error -20003 at location stats_tab_collect-20, SQL statement:

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BEV3/CHCTRGI"', ESTIMATE_PERCENT => 1, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'

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

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

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

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for table SAPSR3./BEV3/CHCTRGI

How we can fix this error?

Thanks

Hernando