ORA-00942 error when compiling invalid CTXSYS.DRIUTL (Doc ID 1079603.1)

Last updated on MAY 01, 2017

Applies to:

Oracle Text - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 14-Oct-2012***

Symptoms

Attempts to recompile the following INVALID objects fail with the same ORA-942 error:

   CTXSYS.DRICON
   CTXSYS.DRIIMP
   CTXSYS.DRIPREF
   CTXSYS.DRITHSC
   CTXSYS.DRITHSL
   CTXSYS.DRIUTL
   CTXSYS.DRIVAL
   CTXSYS.DRIXMD
   CTXSYS.DRVDOC
   CTXSYS.DRVUTL

SQL> show user
USER is "CTXSYS"

SQL> alter package CTXSYS.DRIUTL compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors;
Errors for PACKAGE BODY CTXSYS.DRIUTL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
296/3 PL/SQL: SQL Statement ignored
296/42 PL/SQL: ORA-00942: table or view does not exist

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