Disadvantages of trigger in oracle.

Disadvantages of trigger in Oracle.

Disadvantages of a trigger are as follows:

- Triggers can execute every time some field in database is updated. If a field is likely to be updated often, it is a system overhead.

- Viewing a trigger is difficult compared to tables, views stored procedures.

- It is not possible to track or debug triggers.

- They are not not compiled.

- The SELECT trigger is not support.

- The trigger may fail completely.

- The triggers can be disabled accidentally or dropped by a person.

- The versions cannot be controlled.

- The updation of a column cannot be done at once.

- The SYS table triggers do not support.

- They have mutating triggers.

- The triggers can have a hidden behaviour.