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

ORA-25245: agent name cannot be specified if address is a single-consumer queue or an exception queue

1 Answers  


TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter from SID_DESC

1 Answers  


ORA-31088: object "string"."string" depends on the schema

1 Answers  


PLS-00592: the type of a object table must be an object type

1 Answers  


ORA-30078: partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals

1 Answers  


TNS-04009: %-25s | number

1 Answers  


KUP-00601: fatal XAD error

1 Answers  


ORA-31206: DBMS_LDAP: PL/SQL - Invalid LDAP search scope.

1 Answers  


ORA-13904: The file has been dropped and recreated during the procedure call.

1 Answers  


QSM-01120: recursive rewrite not allowed here

1 Answers  


RMAN-06052: no parent backup or copy of datafile number found

1 Answers  


ORA-16555: The Data Guard database is not active.

1 Answers  


Categories