My Oracle Support Banner

Invalid Sys Objects related to audit like DBA_AUDIT_% in 12.1.0.2 DB (Doc ID 2657593.1)

Last updated on APRIL 28, 2020

Applies to:

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

Symptoms

Invalid SYS objects related to audit in 12.1.0.2 db as shows below. The objects mostly views.

VIEW DBA_AUDIT_EXISTS SYS
VIEW DBA_AUDIT_OBJECT SYS
VIEW DBA_AUDIT_SESSION SYS
VIEW DBA_AUDIT_STATEMENT SYS
VIEW DBA_AUDIT_TRAIL SYS
VIEW DBA_COMMON_AUDIT_TRAIL SYS
VIEW USER_AUDIT_OBJECT SYS
VIEW USER_AUDIT_SESSION SYS
VIEW USER_AUDIT_STATEMENT SYS
VIEW USER_AUDIT_TRAIL SYS

Changes

 NA.

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.