Unified auditing: drop policy doesn't work
Oracle 19c Standard Edition 2:
I cannot drop the policy foestest.
I tried:
noaudit policy foetest;
---> Noaudit erfolgreich. (successfull)
DROP audit POLICY foetest;
--->
Fehler beim Start in Zeile: 14 in Befehl -
DROP audit POLICY foetest
Fehlerbericht -
ORA-46361: Audit-Policy kann nicht gelöscht werden, weil sie aktuell aktiviert ist.
46361. 00000 - "Audit policy cannot be dropped as it is currently enabled."
*Cause: An attempt was made to drop the audit policy which is currently enabled.
*Action: Disable the audit policy before dropping.
Why?