本文探讨了一套运行在11.1.0.7 Oracle Application Object Library的应用在尝试通过fnd_stats.gather_schema_statistics收集schema统计信息时遭遇ORA-20001错误，焦点在于解决AP.JE_FR_DAS_010表的错误，涉及锁定问题和无效列名或重复列名。
一套11.1.0.7上的Oracle Application Object Library应用程序，在收集schema统计信息时出现了ORA-20001错误，具体错误日志如下:
SQL> exec fnd_stats.gather_schema_statistics('AP');
PL/SQL procedure successfully completed.
SQL> show error
No errors.
============================================
Concurrent request error Log
------------------------------------
**Starts**14-APR-2011 02:20:53
**Ends**14-APR-2011 04:40:43
ORA-0000: normal, successful completion
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
In GATHER_SCHEMA_STATS , schema_name= ALL percent= 10 degree = 8 internal_flag= NOBACKUP
stats on table AQ$_WF_CONTROL_P is locked
stats on table FND_CP_GSM_IPC_AQTBL is locked
stats on table WF_NOTIFICATION_OUT is locked
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=AP.JE_FR_DAS_010***ORA-20001: invalid column name or
duplicate columns/column
扫一扫
1050
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
