Oracle Database Errors or Warnings from Error ORA-25011 to ORA-25020

SQLServerF1

ORA-25011: cannot create trigger on internal AQ table
Cause: An attempt was made to try to create a trigger on a table that is used internally to support the Advanced Queueing (AQ) feature.
Action: Do not create the trigger.
ORA-25012: PARENT and NEW values cannot be identical
Cause: The referencing clause specifies identical values for PARENT and OLD.
Action: Re-specify either the PARENT or NEW referencing value.
ORA-25013: OLD and PARENT values cannot be identical
Cause: The referencing clause specifies identical values for OLD and PARENT.
Action: Re-specify either the OLD or PARENT referencing value.

ORA-25014: cannot change the value of a PARENT reference variable
Cause: Parent values can only be read and not changed.
Action: Do not attempt to change a Parent variable.
ORA-25015: cannot perform DML on this nested table view column
Cause: DML cannot be performed on a nested table view column except through an INSTEAD OF trigger
Action: Create an INSTEAD OF trigger over the nested table view column and then perform the DML.
ORA-25016: cannot specify column list for insert into nested table view column
Cause: A column list cannot be specified for inserts into the nested table view column.
Action: Specify all the columns for insert into the nested table.

ORA-25017: cannot reference NEW ROWID for movable rows in before triggers
Cause: NEW ROWID was referenced in a before row trigger which is defined on an index-organized table, or a partitioned table with enabled movement of rows. The ROWID cannot be computed in a before row update trigger because it depends on the actual values of the row
Action: Remove references to NEW ROWID from the trigger definition.
ORA-25018: conflicting trigger string already exists
Cause: Conflicting instead of DDL trigger on schema/database already exists.
Action: Remove the old trigger
ORA-25019: too much concurreny
Cause: cannot pin the database/schema because of too much concurrency
Action: try the operation later
ORA-25020: renaming system triggers is not allowed
Cause: renaming system triggers is not allowed
Action: Drop the trigger, and create a new one for the same

Above are list of Oracle Database Errors or Warnings from Error ORA-25011 to ORA-25020 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *