RE: DBMS_STATS Error

Are you wrapping it with an execute call?  

execute dbms_stats.gather_table_stats(ownname=>
'OPS$ORACLE',tabname=>'TEST',partname=>NULL);
 

PL/SQL procedure successfully completed.    

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DBA Deepak Sent: 24 October 2005 14:41
To: oracle-l_at_freelists.org
Subject: DBMS_STATS Error  

Hi All,  

Getting error while executing the following...  

SQL> begin
  2 dbms_stats.gather_table_stats(ownname=> 'USER01', tabname=>
'MY_TBL', partname=> NULL);

  3 end;
  4 /
 begin
*
ERROR at line 1:

ORA-06521: PL/SQL: Error mapping function 
ORA-06512: at "SYS.DBMS_STATS", line 9643 
ORA-06512: at "SYS.DBMS_STATS", line 9657 
ORA-06512: at line 2 

 

Any pointers to the problem...?

-- 
Regards,

Deepak
Oracle DBA 


--
http://www.freelists.org/webpage/oracle-l