ORA-25002: cannot create INSTEAD OF triggers on tables

Cause : Only BEFORE or AFTER triggers can be created on a table.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Change the trigger type to BEFORE or AFTER.

update : 20-08-2017
ORA-25002

ORA-25002 - cannot create INSTEAD OF triggers on tables
ORA-25002 - cannot create INSTEAD OF triggers on tables

  • ora-19238 : XP0018 - focus not defined
  • ora-08331 : Wait operation timed out
  • ora-02347 : cannot grant privileges on columns of an object table
  • ora-22310 : ALTER TYPE error. Refer to table "string"."string" for errors
  • ora-38462 : invalid attribute list
  • ora-24786 : separated transaction has been completed
  • ora-23440 : incorrect public template value
  • ora-09932 : Close of ORACLE password file failed.
  • ora-32621 : illegal aggregation in UNTIL iteration condition
  • ora-13041 : failed to compare tile with element string.string.string
  • ora-28157 : Proxy user 'string' forbidden to set role 'string' for client 'string'
  • ora-16125 : large transaction string string string is waiting for more data
  • ora-02445 : Exceptions table not found
  • ora-30574 : Cannot create rollback segment in tablespace with AUTO segment space management
  • ora-27500 : inter-instance IPC error
  • ora-30159 : OCIFileOpen: Cannot create the file or cannot open in the requested mode
  • ora-36806 : (XSTBLFUNC03) The OLAP_TABLE function refers to an invalid ADT attribute: string.
  • ora-24046 : protocol attribute reserved for future use
  • ora-12425 : cannot apply policies or set authorizations for system schemas
  • ora-14513 : partitioning column may not be of object datatype
  • ora-12445 : cannot change HIDDEN property of column
  • ora-24390 : Unsupported scrollable cursor operation
  • ora-28049 : the password has expired
  • ora-03251 : Cannot issue this command on SYSTEM tablespace
  • ora-27159 : failure setting process scheduling priority
  • ora-08197 : Flashback Table operation is not supported on clustered tables
  • ora-24342 : unable to destroy a mutex
  • ora-24132 : table name string is too long
  • ora-29664 : Unable to generate the helper class for the defined type
  • ora-13282 : failure on initialization of coordinate transformation
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.