Skip to Content
avatar image
Former Member

dbms_stats error

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 26, 2007 at 06:45 PM

    Try to put additional double quotes around the table name:

    begin

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

    end;

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 28, 2007 at 01:41 PM

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

    Add comment
    10|10000 characters needed characters exceeded