Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-20000

707482Jun 18 2009 — edited Jan 3 2012

Hi,

My database version is 10.2.0.3 and in windows 2003 server. I did defragmentaion using ALter table move command. After that i computed the statistics to whole database. when i gather the table statistics , i am getting the following error.

Error at line 1:
ORA-20000: index "AMS"."IACPT_MER$PRIM" or partition of such index is unusable state.
ORA-06512:at "SYS.DBMS_STATS",,line 13198
ORA-06512:at "SYS.DBMS_STATS",,line 13218
ORA-06512:at line 28

but, there is no index or table partitions in our database.

Now, I am not able to collect the statistics.

Please help me out.
Regards,
Latha

Edited by: user11280437 on Jun 17, 2009 9:38 PM

This post has been answered by 105417 on Jun 18 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 31 2012

Added on Jun 18 2009

#general-database-discussions

12 comments

1,060 views