ORA-30512: cannot modify string.string more than once in a
transaction



ORA-30512: cannot modify string.string more than once in a transaction..

Answer / guest

Cause: An attempt was made to modify an object more than
once in a transaction. This error is usually caused by a DDL
statement that fires a system trigger that tries to modify
the same object. It can also happen when an attempt is made
to perform more than one DDL operation on a queue table in
the same transaction without issuing a commit between
operations.

Action: Do not create system triggers that might modify an
already modified object. Also, do not specify more than one
DDL operation on a queue table in the same transaction.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-11535: error writing phrase or qualifier: string on line string to memory

1 Answers  


ORA-00392: log string of thread string is being cleared, operation not allowed

1 Answers  


ORA-14106: LOGGING/NOLOGGING may not be specified for a clustered table

1 Answers  


ORA-10584: Can not invoke parallel recovery for test recovery

1 Answers  


RMAN-06167: already connected

1 Answers  






PCB-00109: Unable to open generated source file "string"

1 Answers  


DRG-11214: execution of procedure filter stored procedure has failed

1 Answers  


ORA-24064: propagation for QUEUE string and DESTINATION string already enabled

1 Answers  


NCR-04004: NCRR: Invalid interface instance handle

1 Answers  


KUP-03006: error initializing handle for character set string

1 Answers  


PCC-02439: FOR clause not allowed in this COLLECTION statement

1 Answers  


NID-00101: LOGFILE (string) not accessible

1 Answers  


Categories