Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
DBMS_STATS Error

DBMS_STATS Error

2005-10-24       - By Hallas, John, Tech Dev

Reply:     1     2     3     4     5     6     7     8     9  

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@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of DBA Deepak
Sent: 24 October 2005 14:41
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


<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft
-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http:
//www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@(protected)
  {font-family:Tahoma;
  panose-1:2 11 6 4 3 5 4 4 2 4;}
@(protected)
  {font-family:"Comic Sans MS";
  panose-1:3 15 7 2 3 3 2 2 2 4;}
@(protected)
  {font-family:r_ansi;
  panose-1:2 11 6 9 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
  {margin:0cm;
  margin-bottom:.0001pt;
  font-size:12.0pt;
  font-family:"Times New Roman";}
a:link, span.MsoHyperlink
  {color:blue;
  text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
  {color:purple;
  text-decoration:underline;}
span.EmailStyle17
  {mso-style-type:personal-reply;
  font-family:"Comic Sans MS";
  color:blue;
  font-weight:normal;
  font-style:normal;
  text-decoration:none none;}
@(protected) Section1
  {size:595.3pt 841.9pt;
  margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
  {page:Section1;}
-->
</style>

</head>

<body lang=EN-GB link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'>Are you
wrapping it with an execute call?<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'><o:p>&nbsp;</o
:p></span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span
style='font-size:10.0pt;font-family:r_ansi'>execute
dbms_stats.gather_table_stats(ownname=&gt;
'OPS$ORACLE',tabname=&gt;'TEST',partname=&gt;NULL);<o:p></o:p></span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span
style='font-size:10.0pt;font-family:r_ansi'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="r_ansi"><span
style='font-size:10.0pt;font-family:r_ansi'>PL/SQL procedure successfully
completed.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'><o:p>&nbsp;</o
:p></span></font></p>

<p class=MsoNormal><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'><o:p>&nbsp;</o
:p></span></font></p>

<div>

<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>

<hr size=2 width="100%" align=center tabindex=-1>

</span></font></div>

<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font
></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <b><span
style='font-weight:bold'>On Behalf Of </span></b>DBA Deepak<br>
<b><span style='font-weight:bold'>Sent:</span></b> 24 October 2005 14:41<br>
<b><span style='font-weight:bold'>To:</span></b> oracle-l@(protected)<br>
<b><span style='font-weight:bold'>Subject:</span></b> DBMS_STATS Error</span><
/font><span
lang=EN-US><o:p></o:p></span></p>

</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hi All,<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Getting error while executing the&nbsp;following...<o:p></o:p></span><
/font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>SQL&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; begin<br>
&nbsp; 2&nbsp; dbms_stats.gather_table_stats(ownname=&gt; 'USER01',
tabname=&gt; 'MY_TBL', partname=&gt; NULL);<br>
&nbsp; 3&nbsp; end;<br>
&nbsp; 4&nbsp; /<br>
&nbsp;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 &quot;SYS.DBMS_STATS&quot;, line 9643 <br>
ORA-06512 (See ORA-06512.ora-code.com): at &quot;SYS.DBMS_STATS&quot;, line 9657 <br>
ORA-06512 (See ORA-06512.ora-code.com): at line 2 <o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Any pointers to the problem...?<br clear=all>
<br>
-- <br>
Regards,<br>
<br>
Deepak<br>
Oracle DBA <o:p></o:p></span></font></p>

</div>

</div>

</body>

</html>