DBMS_STATS Error

Links

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 Enrique Fernandez-Pampillon

Reply: 1 2 3 4 5 6 7 8 9

Was your Oracle well installed?. The problem is Oracle isn't be able to link
a dynamic library. Has the alert any message? LD_LIBRARY_PATH well
configured?
HTH
Enrique

On 10/24/05, DBA Deepak <oracle.tutorials@(protected)> wrote:
>
> 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
>

--
-- ---- ---- ---- ---- ---- ---- ---- ---- -----
Enrique

<div>Was your Oracle well installed?. The problem is Oracle isn't be able to
link a dynamic library. Has the alert any message? LD_LIBRARY_PATH well
configured?</div>
<div> </div>
<div>HTH</div>
<div> </div>
<div>Enrique<br><br> </div>
<div><span class="gmail_quote">On 10/24/05, <b class="gmail_sendername">DBA
Deepak</b> <<a href="mailto:oracle.tutorials@(protected)">oracle.tutorials
@(protected)</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<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 &quot
;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></div><br><br clear="all"><br>-- <br>--
-- ---- ---- ---- ---- ---- ---- ---- ---- ---<br>Enrique