ORA-30512: cannot modify string.string more than once in a
transaction
- 1 Answers
- 3224 Views
- I also Faced
- E-Mail Answers
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 |
ORA-23318: a ddl failure has occurred
ORA-00081: address range [string, string) is not readable
ORA-16090: archive log to be replaced not created by managed standby process
PCC-02451: Value of offset cannot be negative in ABSOLUTE orientation mode
ORA-02355: error opening file: string
ORA-01639: instance string has no thread assigned to it
PROT-00304: Failed to create dump file
RMAN-12009: command aborted because some backup pieces could not be located
RMAN-05512: tablespace string cannot be skipped from duplication
ORA-12196: TNS:received an error from TNS
ORA-06569: Collection bound by bind_array contains no elements
ORA-13126: unable to determine class for spatial table string
Oracle Errors 
