| dbms_stats problem [message #221427] |
Mon, 26 February 2007 13:28  |
rkl1
Messages: 97
Registered: June 2005
|
Member |
|
|
Dear All, We got a big Fact Table which is based on range partition and then subpartitioned by LIST. This table has 14 Local indexes. I can run the dbms_stats on the indexes and no problem. However when I run the dbms_stats on the table, it spits out error:
ORA-08103: object no longer exists
ORA-06512: at "SYS.DBMS_STATS", line 10502
ORA-06512: at "SYS.DBMS_STATS", line 10516
How it is possible when I can get the count(*) from the same table, describe the same table and even collect statistiscs on its indexes.
I tried to run the OLD analyze command and gets the similar error message. I did run the analyze command for validate structure and it gives also the error message. The database is running on 9.2.0.8 and it is in solaris 9.0. Has any one experienced similar trouble?
Any suggestion would be appreciated.
Thanks.
|
|
|
|
| Re: dbms_stats problem [message #221434 is a reply to message #221427] |
Mon, 26 February 2007 13:47  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
There are a few known quirks around this.
Try a higher sampling size
ANALYZE TABLE table_name ESTIMATE STATISTICS SAMPLE 60 PERCENT;
If this succeeds, it is a known bug. Raise a TAR.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
