一套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
本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1277755