18c: ORA-00933: "SQL Command Not Properly Ended" when creating a Unified Audit Policy with ONLY TOPLEVEL clause (18c and lower)
(Doc ID 2696666.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 18]
Information in this document applies to any platform.
1. You have Unified Auditing set up and want to enable an audit policy to audit ALL actions, but want to avoid filling up the audit trail so you want to also add the "ONLY TOPLEVEL" clause.
2. However, when you run the above SQL (on 18c), you get an error:
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