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 laterInformation 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 |