ORA-12831: Must COMMIT or ROLLBACK after executing INSERT
with APPEND hint



ORA-12831: Must COMMIT or ROLLBACK after executing INSERT with APPEND hint..

Answer / guest

Cause: After executing an INSERT statement with an APPEND
hint, a command other than COMMIT or ROLLBACK was issued.

Action: Execute COMMIT or ROLLBACK before issuing another
SQL command.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00000: Not An Error

1 Answers  


ORA-39142: incompatible version number string in dump file "string"

1 Answers  


ORA-08401: invalid compiler name: string

1 Answers  


AUD-00803: internal error while processing WHERE clause

1 Answers  


ORA-10580: Can not modify datafile header during test recovery

1 Answers  






ORA-25189: illegal ALTER TABLE option for an index-organized table

1 Answers  


TNS-00018: INTCTL: TNS_ADMIN not defined

1 Answers  


ORA-31432: invalid source table

1 Answers  


NNL-00349: Configuration will be saved in string

1 Answers  


ORA-01866: the datetime class is invalid

3 Answers  


ORA-32633: MODEL subquery FOR cell index returns too many rows

1 Answers  


ORA-25223: user_data type used is not supported

1 Answers  


Categories