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

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

Question Posted / guest

1 Answers
3924 Views
I also Faced
E-Mail Answers

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

ORA-12542: TNS:address already in use

1 Answers

PLS-00644: character set mismatch found at 'string' among result expressions in a CASE expression

1 Answers

PLS-00920: parameter plsql_native_library_dir is not set

1 Answers

ORA-31901: the current operation was cancelled by the user

1 Answers

ORA-31021: Element definition not found

1 Answers

RMAN-20033: controlfile sequence# too low

1 Answers

SQL*Loader-00408: Physical record stack overflow

1 Answers

QSM-02048: outer join in mv

1 Answers

TNS-00516: Permission denied

1 Answers

ORA-16104: invalid Logical Standby option requested

1 Answers

LFI-00125: Random access only allowed on fixed length record files.

1 Answers

ORA-12039: unable to use local rollback segment "string"

1 Answers

For more Oracle Errors Interview Questions Click Here