Gather Schema Statistics Errors with APPS.EUL5_B<number> ORA-20000 Unable to analyze TABLE
(Doc ID 1680854.1)
Last updated on MAY 30, 2024
Applies to:
Oracle E-Business Suite Performance - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]Information in this document applies to any platform.
Symptoms
Running the Gather Schema Statistics request errors with:
FNDGSCST module: Gather Schema Statistics%
+---------------------------------------------------------------------------+
Current system time is 24-MAY-2014 02:00:11
+---------------------------------------------------------------------------+
**Starts**24-MAY-2014 02:00:11
**Ends**25-MAY-2014 03:13:20
ORA-0000: normal, successful completion
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
In GATHER_SCHEMA_STATS , schema_name= ALL percent= 30 degree = 80 internal_flag= NOBACKUP Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=APPS.EUL5_B140509030409Q2R731***ORA-20000: Unable to analyze TABLE "APPS"."EUL5_B140509030409Q2R731", insufficient privileges or does not exist*** Error #2: ERROR: While GATHER_TABLE_STATS:
object_name=APPS.EUL5_B140509030409Q3R731***ORA-20000: Unable to analyze TABLE "APPS"."EUL5_B140509030409Q3R731", insufficient privileges or does not exist*** Error #3: ERROR: While GATHER_TABLE_STATS:
One can check the table from sqlplus where they won't be available:
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |