RE: DBMS_STATS Error

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <oracle.tutorials@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 24 Oct 2005 10:33:43 -0400

Deepak,

 

You need to check Metalink for this error.  It might be a bug of some
kind.  Does this problem exist for other tables?


Tom

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DBA Deepak
Sent: Monday, October 24, 2005 9:41 AM
To: oracle-l@xxxxxxxxxxxxx
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 

Other related posts: