TMS Procedure AnalyzeTables Fails with ORA-6512; ORA-8104 (Doc ID 301787.1)

Last updated on NOVEMBER 14, 2016

Applies to:

Oracle Thesaurus Management System - Version 4.0.6 to 4.6.1 [Release 4.0.0 to 4.6.0]
Information in this document applies to any platform.
***Checked for relevance on 13-Nov-2008***
***Checked for relevance on 16-APR-2010***
***Checked for relevance on 24-OCT-2011***
***Checked for relevance on 10-JAN-2014***
***Checked for relevance on 11-JUN-2015***


Symptoms

TMS procedure AnalyzeTables is failing with the following error messages:

SQL> exec tms_user_analyze.AnalyzeTables
BEGIN tms_user_analyze.AnalyzeTables; END;
*
ERROR at line 1:
ORA-20000: 347800-Analyze tables failed
ORA-06512: at "OPA.OPA_USER_MSG", line 95
ORA-06512: at "TMS.TMS_USER_ANALYZE", line 12
ORA-06512: at "TMS.TMS_USER_ANALYZE", line 19
ORA-06512: at line 1





Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms