ORA-01914: invalid auditing option for sequence numbers
Cause: AUDIT or NOAUDIT on a sequence number specifies an auditing option that is not legal for sequence numbers.
Action: The following options may not be used for sequence numbers and should be removed: COMMENT, DELETE, INDEX, INSERT, LOCK, RENAME, UPDATE, REFERENCES, EXECUTE
ORA-01914错误指示无效的审计选项用于序列号。
官方解释
ORA-01914: invalid auditing option for sequence numbers
Cause: An attempt was made to set an audit option for a sequence number.
Action: Remove the sequence number from the auditing option statement.
常见案例
一般情况下,当您尝试为序列设置审计选项时,会发生这个ORA-01914错误。
正常处理方法及步骤
解决ORA-01914错误的正确方法是从审计选项声明中删除序列号。