oracle error- ORA-00981: cannot mix table and system auditing options

Oracle error
oracle, oracle error, oracle blog
ORA-00981: cannot mix table and system auditing options


Cause: Table and system-wide auditing options were specified in the same AUDIT or NOAUDIT statement.
Action: You must issue table and system options in separate statements.

See more oracle error here.

oracle error- ORA-00980: synonym translation is no longer valid

Oracle error
oracle, oracle error, oracle blog
ORA-00980: synonym translation is no longer valid


Cause: A synonym did not translate to a legal target object. This could happen for one of the following reasons:1. The target schema does not exist. 2. The target object does not exist. 3. The synonym specifies an incorrect database link. 4. The synonym is not versioned but specifies a versioned target object.
Action: Change the synonym definition so that the synonym points at a legal target object.



See more oracle error here.

oracle error- ORA-00977: duplicate auditing option

Oracle error
oracle, oracle error, oracle blog
ORA-00977: duplicate auditing option


Cause: AUDIT or NOAUDIT statement specifies an option more than once
Action: Either use ALL with no other auditing options or make sure no option is listed more than once.

See more oracle error here.