How to fix the Oracle error ORA-32595: DDL statement cannot be audited with BY SESSION specified?

In this post, you’ll learn more about the Oracle ErrorORA-32595: DDL statement cannot be audited with BY SESSION specified with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-32595: DDL statement cannot be audited with BY SESSION specified

Reason for the Error ORA-32595: DDL statement cannot be audited with BY SESSION specified

An attempt was made to audit a DDL statement with BY SESSION clause specified. DDL statements can be audited BY ACCESS only.

How to fix the Error ORA-32595: DDL statement cannot be audited with BY SESSION specified ?

You can fix this error in Oracle by following the below steps

Specify BY ACCESS instead of BY SESSION to audit the DDL statement.