Hi All,
Gather Schema Statistics failed with following error. I have found the document "Concurrent Request 'Gather Schema Statistics' Errors With ORA-20000: Unable to Analyze TABLE "APPS"."<object>", Insufficient Privileges or Does Not Exist (Doc ID 2354215.1)" but there are no such objects in database.
EBS: R12.2.7
DB: 12.1.0.2
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
FNDGSCST: Gather Schema Statistics
+---------------------------------------------------------------------------+
Current system time is 11-APR-2019 09:04:38
+---------------------------------------------------------------------------+
**Starts**11-APR-2019 09:04:38
**Ends**11-APR-2019 12:24:17
ORA-0000: normal, successful completion
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
fnd_trace start_trace...identifier: 0411_090438 sid/serial/module/action: 403/39661/e:SYSADMIN:cp:fnd/FNDGSCST/SYSADMIN/SYSTEM_ADMINISTRATOR
SET_IDENT_FOR_SESS: user: SYSADMIN, requestID: 7596112
FND_TRACE.start_trace: Starting PL/SQL Profiler
START_PLSQL_PROFILER_PVT: Related Run Id is 7276446
START_PLSQL_PROFILER_PVT: Started the PL/SQL profiler for runid 2
In GATHER_SCHEMA_STATS , schema_name= ALL percent= 1 degree = 8 internal_flag= NOBACKUP
stats on table FND_MBL_NOTIFICATION_OUT is locked
stats on table CUSTOM_JMS_OUT is locked
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=CSF.MDXT_6A30C$_MBR***ORA-20000: Unable to analyze TABLE "CSF"."MDXT_6A30C$_MBR", insufficient privileges or does not exist***
Error #2: ERROR: While GATHER_TABLE_STATS:
object_name=CSF.MDXT_6A314$_MBR***ORA-20000: Unable to analyze TABLE "CSF"."MDXT_6A314$_MBR", insufficient privileges or does not exist***
Error #3: ERROR: While GATHER_TABLE_STATS:
object_name=CSF.MDXT_6A31C$_MBR***ORA-20000: Unable to analyze TABLE "CSF"."MDXT_6A31C$_MBR", insufficient privileges or does not exist***
Error #4: ERROR: While GATHER_TABLE_STATS:
object_name=CSF.MDXT_6A324$_MBR***ORA-20000: Unable to analyze TABLE "CSF"."MDXT_6A324$_MBR", insufficient privileges or does not exist***
Error #5: ERROR: While GATHER_TABLE_STATS:
object_name=CSF.MDXT_6A32C$_MBR***ORA-20000: Unable to analyze TABLE "CSF"."MDXT_6A32C$_MBR", insufficient privileges or does not exist***
Error #6: ERROR: While GATHER_TABLE_STATS:
object_name=CSF.MDXT_6A334$_MBR***ORA-20000: Unable to analyze TABLE "CSF"."MDXT_6A334$_MBR", insufficient privileges or does not exist***
Error #7: ERROR: While GATHER_TABLE_STATS:
object_name=CSF.MDXT_6A33C$_MBR***ORA-20000: Unable to analyze TABLE "CSF"."MDXT_6A33C$_MBR", insufficient privileges or does not exist***
Error #8: ERROR: While GATHER_TABLE_STATS:
object_name=CSF.MDXT_6A344$_MBR***ORA-20000: Unable to analyze TABLE "CSF"."MDXT_6A344$_MBR", insufficient privileges or does not exist***
Error #9: ERROR: While GATHER_TABLE_STATS:
object_name=CSF.MDXT_6A34C$_MBR***ORA-20000: Unable to analyze TABLE "CSF"."MDXT_6A34C$_MBR", insufficient privileges or does not exist***
Error #10: ERROR: While GATHER_TABLE_STATS:
object_name=CSF.MDXT_6A354$_MBR***ORA-20000: Unable to analyze TABLE "CSF"."MDXT_6A354$_MBR", insufficient privileges or does not exist***
fnd_trace stop_trace...trace is already disabled. sid/serial/module/action: 403/39661/e:SYSADMIN:cp:fnd/FNDGSCST/SYSADMIN/SYSTEM_ADMINISTRATOR
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.
Output file size:
0
Deleting empty output file.
Thanks,
Ramaraju
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 11-APR-2019 12:24:45
+---------------------------------------------------------------------------+