Error while trying to compute Schema Statistics [message #233478] |
Thu, 26 April 2007 05:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
grahambo
Messages: 9 Registered: November 2006
|
Junior Member |
|
|
Hi All,
I wonder if you could help me?
I am attempting to analyze a particular schema within my oracle 9i database.
however it keeps throwing up and error.
SQL> exec DBMS_UTILITY.ANALYZE_SCHEMA('TOPTEAMDB','COMPUTE');
BEGIN DBMS_UTILITY.ANALYZE_SCHEMA('TOPTEAMDB','COMPUTE'); END;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [25012], [5], [0], [], [], [], [],
[]
ORA-06512: at "SYS.DBMS_DDL", line 179
ORA-06512: at "SYS.DBMS_UTILITY", line 472
ORA-06512: at line 1
I'm fairly new to oracle and have no idea why this is happening.
if anyone knows why or how to fix it please let me know.
thanks
Graham
|
|
|
|
|
Re: Error while trying to compute Schema Statistics [message #233486 is a reply to message #233481] |
Thu, 26 April 2007 06:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
No, I mean Oracle support.
ora-00600: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]
*Cause: This is the generic internal error number for Oracle program
exceptions. This indicates that a process has encountered an
exceptional condition.
*Action: Report as a bug - the first argument is the internal error number
You can also check on Metalink ORA-600 lookup.
Regards
Michel
|
|
|
|
Re: Error while trying to compute Schema Statistics [message #233537 is a reply to message #233478] |
Thu, 26 April 2007 08:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
grahambo
Messages: 9 Registered: November 2006
|
Junior Member |
|
|
Hi Thanks your your reply
I tried this
SQL> exec DBMS_STATS.GATHER_SCHEMA_STAT('TOPTEAMDB',DBMS_STATS.AUTO_SAMPLE_SIZE);
BEGIN DBMS_STATS.GATHER_SCHEMA_STATS ('TOPTEAMDB',DBMS_STATS.AUTO_SAMPLE_SIZE);
END;
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
However as you can now see im getting a different error.
Any ideas?
|
|
|
|