Compiling CTXSYS.DRIERR results in ORA-01031: insufficient privileges

(Doc ID 1389187.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Text - Version: 10.2.0.3 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

Attempting to recompile invalid package CTXSYS.DRIERR may fail with the following:

SQL> show user;
USER is "SYS"
SQL> ALTER PACKAGE CTXSYS.DRIERR COMPILE;

Warning: Package altered with compilation errors.

SQL> SHOW ERRORS PACKAGE BODY CTXSYS.DRIERR;
Errors for PACKAGE BODY CTXSYS.DRIERR:

LINE/COL ERROR
-------------- -----------------------------------------------------------------
8/3              PL/SQL: SQL Statement ignored
8/19            PL/SQL: ORA-01031: insufficient privileges

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms