ORA-12830: Must COMMIT or ROLLBACK after executing parallel
INSERT/UPDATE/DELETE



ORA-12830: Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE..

Answer / guest

Cause: After executing a parallel INSERT/UPDATE/DELETE
statement, 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 ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01088: cannot shut down ORACLE while active processes exist

1 Answers  


ORA-02235: this table logs changes to another table already

1 Answers  


NNL-00539: start|startup [<args>] : start the Names server with optional arguments

1 Answers  


ORA-30990: insufficient privileges to change owner of resource string

1 Answers  


ORA-26050: Direct path load of domain index is not supported for this column type.

1 Answers  






ORA-22956: The set contains no elements

1 Answers  


ORA-26001: Index string specified in SORTED INDEXES does not exist on table string

1 Answers  


ORA-07512: sscggtl: $enq unexpected return for client termination lock

1 Answers  


ORA-12438: repeated policy option: string

1 Answers  


RMAN-08580: channel string: starting datafile copy

1 Answers  


ORA-16534: no more requests accepted

1 Answers  


ORA-02067: transaction or savepoint rollback required

1 Answers  


Categories