Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBMS_STATS Error

RE: DBMS_STATS Error

From: Ignizio, Richard <richard.ignizio_at_PaeTec.com>
Date: Mon, 24 Oct 2005 10:15:10 -0400
Message-ID: <D63E582D09D77648A106C164FC7C483203C3CB41@mail1-corp.corp.paetec.com>


There is no need for a declare or an Execute:  

  1 begin
  2 dbms_stats.gather_table_stats(ownname=>'XXX',tabname=>'XXX',partname=>NULL);   3* end;

PL/SQL procedure successfully completed.  

What version of Oracel are you running?    

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Michael.Coll-Barth_at_VerizonWireless.com Sent: Monday, October 24, 2005 9:55 AM
To: oracle-l_at_freelists.org
Subject: RE: DBMS_STATS Error

Deepak,  

Try sticking a 'DECLARE' statement before your pl/sql block.  

Michael  

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DBA Deepak Sent: Monday, October 24, 2005 9:41 AM
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 Received on Mon Oct 24 2005 - 09:27:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US