Patch Reviews - ENM (MOSC)

MOSC Banner

dbms_stats.gather_table_stat gets corrupted after apply this patch Patch 31969301: MERGE REQUEST ON

this error raise for any table in the database.

BEGIN sys.dbms_stats.gather_table_stats ( ownname => 'invoice',tabname => 'STA_RAW'); END;

Error report -

ORA-20000: Unable to analyze TABLE "INVOICE"."STA_RAW", insufficient privileges or does not exist

ORA-06512: at "SYS.DBMS_STATS", line 35240

ORA-06512: at line 1

20000. 00000 - "%s"

*Cause:   The stored procedure 'raise_application_error'

          was called which causes this error to be generated.

*Action:  Correct the problem as described in the error message or contact

          the application administrator or DBA for more information.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center