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-06602: LU6.2 Driver: Error allocating context area

1 Answers  


ORA-00486: ASMB process terminated with error

1 Answers  


PLS-00530: Illegal type used for object type attribute: 'string'.

1 Answers  


NNO-00633: detected fatal delegation loop involving server "string"

1 Answers  


ORA-26671: maximum number of STREAMS processes exceeded

1 Answers  






ORA-24122: invalid block range specification

1 Answers  


ORA-31640: unable to open dump file "string" for read

1 Answers  


ORA-12911: permanent tablespace cannot be temporary tablespace

1 Answers  


NNL-00555: Displays meta data statistics

1 Answers  


ORA-12994: drop column option only allowed once in statement

1 Answers  


ORA-40004: penalty must be negative for BLAST-N

1 Answers  


ORA-13448: GeoRaster metadata BRS error

1 Answers  


Categories