Compiling CTXSYS.DRIERR results in ORA-01031: insufficient privileges
(Doc ID 1389187.1)
Last updated on JUNE 21, 2022
Applies to:
Oracle Text - Version 10.2.0.3 and laterInformation 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
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
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 |