dbms_stats error

[Former Member]

Oracle: 9.2.0.8

O/S: HP-UX B11.11

I get this error? Any advice?

begin

dbms_stats.gather_table_stats(ownname=> 'SAPDWS', tabname=> '/BDL/CUST', partname=> NULL);

end;

/

ORA-06502: PL/SQL: numeric or value error

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

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

ORA-06512: line 2

[Former Member · Accepted solution]

Try to put additional double quotes around the table name:

begin

dbms_stats.gather_table_stats(ownname=> 'SAPDWS', tabname=> '"/BDL/CUST"', partname=> NULL);

end;

[former_member204746]

try updating BRTOOLS to version 6.40 and to latest patch level.