5 Replies Latest reply on Apr 15, 2019 6:46 AM by Kanda-Oracle

    Gather Schema Statistics Failed

    Ramaraju

      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

       

      +---------------------------------------------------------------------------+