Gathering table stats fails with ORA-904 error in 18c if the job is not owned by SYS user
(Doc ID 2604279.1)
Last updated on NOVEMBER 01, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
+ This is Oracle VPD (Virtual Private Database), version 126.96.36.199.0.
+ Gathering table stats fails with ORA-904 error in 18c if the job is not owned by SYS user. This was working fine in 12.2.
+ This was working fine in 12.2. The "lid" is different between 12.2 and 18c.
+ The lid (privilege user id) maps to the uid (parse schema user) rather than SYS.
+ This behavior exists on 18c. On 188.8.131.52, the lid=0 (i.e: SYS).
DB upgrade from 184.108.40.206 to 18.5
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