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

ORA-29368: consumer group string does not exist

1 Answers  


ORA-12208: TNS:could not find the TNSNAV.ORA file

1 Answers  


ORA-34342: (MXDSS01) IMPORTANT: Analytic workspace string is read-only. Therefore, you will not be able to use the UPDATE command to save changes to it.

1 Answers  


NNO-00064: loading domain data from checkpoint file "string"

1 Answers  


ORA-22956: The set contains no elements

1 Answers  






SQL*Loader-00106: Invalid discard file name on command line

1 Answers  


ORA-30107: parameter name abbreviation 'string' is not unique

1 Answers  


ORA-28611: bitmap index is corrupted - see trace file for diagnostics

1 Answers  


ORA-16186: Modifying LOG_ARCHIVE_CONFIG requires SID='*' qualifier

1 Answers  


ORA-13627: Setting of parameter string is disallowed until the task is reset.

1 Answers  


RMAN-06736: Do you really want to unregister the database (enter YES or NO)?

1 Answers  


ORA-24353: user buffer too small to accommodate COBOL display type

1 Answers  


Categories