一套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

總結

以上是生活随笔為你收集整理的oracle发生20001,ORA-20001错误一例的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。