Home » RDBMS Server » Server Administration » Compute works but estimate does not.
Compute works but estimate does not. [message #192425] Tue, 12 September 2006 05:54 Go to next message
Messages: 59
Registered: July 2005
Location: Glasgow
Hi there,

I'm running Oracle 9i on Sun Solaris.

I'm getting the following error message when trying to analyze a table.

This table has been dropped and recreated - error remains

It occurs when the table has been populated and after it's truncated.

The table is on an LMT with Uniform Extent size of 1m

The table itself only has 277 rows.

SQL> analyze table SR_EXTRACT_STDKEY_SUMMARY estimate statistics;
analyze table SR_EXTRACT_STDKEY_SUMMARY estimate statistics
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcbgtcr_12], [1], [], [], [], [],
[], []

SQL> analyze table SR_EXTRACT_STDKEY_SUMMARY compute statistics;

Table analyzed.
Re: Compute works but estimate does not. [message #192446 is a reply to message #192425] Tue, 12 September 2006 07:39 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Metalink note 233612.1 lists this as a known bug.

Previous Topic: Oracle 7.3 on linux(urgent)
Next Topic: Active Directory
Goto Forum:

Current Time: Wed Oct 26 06:28:46 CDT 2016

Total time taken to generate the page: 0.08887 seconds