In this post, you’ll learn more about the Oracle ErrorORA-00977: duplicate auditing option with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-00977: duplicate auditing option
Reason for the Error ORA-00977: duplicate auditing option
AUDIT or NOAUDIT statement specifies an option more than once
How to fix the Error ORA-00977: duplicate auditing option ?
You can fix this error in Oracle by following the below steps
Either use ALL with no other auditing options or make sure no option is listed more than once.