My Oracle Support Banner

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 MARCH 12, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 18.3.0.0.0 to 18.9.0.0.0 [Release 18]
Information in this document applies to any platform.

Symptoms

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:



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.