Compute works but estimate does not. [message #192425] |
Tue, 12 September 2006 05:54  |
alliejane
Messages: 59 Registered: July 2005 Location: Glasgow
|
Member |
|
|
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.
|
|
|
|