Error Logging Restrictions & Caveats Oracle Database logs errors - Oracle Tables

Q.  Error Logging Restrictions and Caveats Oracle Database logs which of the following errors during DML operations?

- Published on 12 Aug 15

a. Column values those are too large
b. Constraint violations (NOT NULL, unique, referential, and check constraints)
c. Errors raised during trigger execution
d. Partition mapping errors
e. All mentioned above

ANSWER: All mentioned above

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 01 Sep 15
    - Oracle Database logs the following errors during DML operations:

    1. Column values that are too large

    2. Constraint violations (NOT NULL, unique, referential, and check constraints)

    3. Errors raised during trigger execution

    4. Errors resulting from type conversion between a column in a subquery and the corresponding column of the table

    5. Partition mapping errors

    6. Certain MERGE operation errors (ORA-30926: Unable to get a stable set of rows for MERGE operation.)

    - Some errors are not logged, and cause the DML operation to terminate and roll back.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲