DBMS_STATS Error 2005-10-24 - By Ignizio, Richard
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@(protected) [mailto:oracle-l-bounce@(protected)]On
Behalf Of Michael.Coll-Barth@(protected)
Sent: Monday, October 24, 2005 9:55 AM
To: oracle-l@(protected)
Subject: RE: DBMS_STATS Error
Deepak,
Try sticking a 'DECLARE' statement before your pl/sql block.
Michael
-- --Original Message-- --
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]On
Behalf Of DBA Deepak
Sent: Monday, October 24, 2005 9:41 AM
To: oracle-l@(protected)
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 (See ORA-06521.ora-code.com): PL/SQL: Error mapping function
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STATS", line 9643
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STATS", line 9657
ORA-06512 (See ORA-06512.ora-code.com): at line 2
Any pointers to the problem...?
--
Regards,
Deepak
Oracle DBA
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1515" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=755271114-24102005><FONT face=Arial color=#0000ff size=2>There
is no need for a declare or an Execute:</FONT></SPAN></DIV>
<DIV><SPAN class=755271114-24102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=755271114-24102005><FONT face=Arial color=#0000ff size=2> 
;
1 begin<BR> 2
dbms_stats.gather_table_stats(ownname=>'XXX',tabname=>'XXX',partname=>
;NULL);<BR>
3* end;<BR></FONT></SPAN><SPAN class=755271114-24102005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN></DIV>
<DIV><SPAN class=755271114-24102005><FONT face=Arial color=#0000ff size=2>PL
/SQL
procedure successfully completed.</FONT></SPAN></DIV>
<DIV><SPAN class=755271114-24102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=755271114-24102005><FONT face=Arial color=#0000ff size=2>What
version of Oracel are you running?</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=755271114-24102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-- --Original Message-- --<BR><B>From:</B>
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]<B>On
Behalf Of </B>Michael.Coll-Barth@(protected)<BR><B>Sent:</B> Monday,
October 24, 2005 9:55 AM<BR><B>To:</B>
oracle-l@(protected)<BR><B>Subject:</B> RE: DBMS_STATS
Error<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=239015213-24102005>Deepak,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=239015213-24102005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=239015213-24102005>Try
sticking a 'DECLARE' statement before your pl/sql block.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=239015213-24102005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=239015213-24102005>Michael</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=239015213-24102005></SPAN></FONT> </DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-- --Original Message-- --<BR><B>From:</B>
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]<B>On
Behalf Of </B>DBA Deepak<BR><B>Sent:</B> Monday, October 24, 2005 9:41
AM<BR><B>To:</B> oracle-l@(protected)<BR><B>Subject:</B> DBMS_STATS
Error<BR><BR></FONT></DIV>
<DIV>Hi All,</DIV>
<DIV> </DIV>
<DIV>Getting error while executing the following...</DIV>
<DIV> </DIV>
<DIV>SQL> begin<BR> 2
dbms_stats.gather_table_stats(ownname=> 'USER01', tabname=> 'MY_TBL',
partname=> NULL);<BR> 3 end;<BR> 4
/<BR> begin<BR>*<BR>ERROR at line 1:<BR>ORA-06521 (See ORA-06521.ora-code.com): PL/SQL: Error mapping
function <BR>ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STATS", line 9643 <BR>ORA-06512 (See ORA-06512.ora-code.com): at
"SYS.DBMS_STATS", line 9657 <BR>ORA-06512 (See ORA-06512.ora-code.com): at line 2 </DIV>
<DIV> </DIV>
<DIV>Any pointers to the problem...?<BR clear=all><BR>--
<BR>Regards,<BR><BR>Deepak<BR>Oracle DBA </DIV></BLOCKQUOTE></BODY></HTML>
|
|
