My Oracle Support Banner

Invalid Outline Objects In SYS Schema, Compile is Failing With ORA-00942 (Doc ID 2497506.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Invalid Outline Objects In SYS Schema, Compile is Failing With below errors:

Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY DBMS_SQLTCB_INTERNAL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1570/5 PL/SQL: SQL Statement ignored
1571/18 PL/SQL: ORA-00942: table or view does not exist

Package body created.

select * from dba_objects where status='INVALID' and owner in ('SYS','SYSTEM') order by owner, object_name;

OWNER    OBJECT_NAME               S  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE   CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S  NAMESPACE EDITION_NAME    SHARI E O
-------- ------------------------- - ---------- -------------- ------------- --------- --------- ------------------- ------- - - - ---------- --------------- ----- - -
SYS      DBA_OUTLINES                      5504                VIEW          16-OCT-10 01-JAN-19 2019-01-01:20:20:11 INVALID N N N          1                 NONE  N Y
SYS      DBA_OUTLINE_HINTS                 5509                VIEW          16-OCT-10 01-JAN-19 2019-01-01:20:20:11 INVALID N N N          1                 NONE  N Y
SYS      DBMS_SQLTCB_INTERNAL              9716                PACKAGE BODY  16-OCT-10 01-JAN-19 2019-01-01:20:12:36 INVALID N N N          2                 NONE  N Y
SYS      KU$_OUTLINE_VIEW                  6837                VIEW          16-OCT-10 01-JAN-19 2019-01-01:20:12:36 INVALID N N N          1                 NONE  N Y
SYS      OUTLN_PKG                         5530                PACKAGE BODY  16-OCT-10 01-JAN-19 2019-01-01:20:12:35 INVALID N N N          2                 NONE  N Y
SYS      USER_OUTLINES                     5501                VIEW          16-OCT-10 01-JAN-19 2019-01-01:20:20:11 INVALID N N N          1                 NONE  N Y
SYS      USER_OUTLINE_HINTS                5506                VIEW          16-OCT-10 01-JAN-19 2019-01-01:20:20:11 INVALID N N N          1                 NONE  N Y

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.