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-26716: message limit reached

1 Answers  


NNF-01001: ds_initialize: workspace initialization failed

1 Answers  


ORA-02831: Segment deallocation failed - empty segment list

1 Answers  


ORA-14063: Unusable index exists on unique/primary constraint key

1 Answers  


ORA-16640: CRS warns that multiple instances may still be running.

1 Answers  






CLSR-00003: ORACLE_HOME environment variable not set

1 Answers  


NNL-00208: Cancelled reload check

1 Answers  


ORA-13051: failed to initialize spatial object

1 Answers  


ORA-25455: evaluation error for rule set: string.string, evaluation context: string.string

1 Answers  


ORA-28153: Invalid client initial role specified: 'string'

1 Answers  


ORA-12626: TNS:bad event type

1 Answers  


ORA-14304: List partitioning method expects a single partitioning column

1 Answers  


Categories