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 : 29-04-2017
ORA-25002

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

  • ora-24316 : illegal handle type
  • ora-30932 : Reference node 'string' not contained in specified parent node 'string'
  • ora-38485 : invalid object type for the user-defined function
  • ora-24753 : local transactions cannot be detached
  • ora-31090 : invalid database schema name "string"
  • ora-25267 : didnt specify the signature for a reciever non-repudiable queue
  • ora-06541 : PL/SQL: compilation error - compilation aborted
  • ora-39098 : Worker process received data objects while loading metadata. Invalid process order range is string..string
  • ora-01278 : error creating file 'string'
  • ora-13034 : Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object
  • ora-23337 : priority or value not in priority group string
  • ora-07405 : sptrap: cannot setup alternate signal stack.
  • ora-02803 : Retrieval of current time failed
  • ora-02246 : missing EVENTS text
  • ora-06009 : NETASY: dialogue filename too long
  • ora-06700 : TLI Driver: incorrect message type from host
  • ora-16053 : DB_UNIQUE_NAME string is not in the Data Guard Configuration
  • ora-38468 : column "string" is not identified as a column storing expressions.
  • ora-30031 : the suspended (resumable) statement has been aborted
  • ora-25273 : AQ QMN process alternate cleanup event
  • ora-00134 : invalid DISPATCHERS specification #string
  • ora-00233 : copy control file is corrupt or unreadable
  • ora-16035 : missing required keyword string
  • ora-01646 : tablespace 'string' is not read only - cannot make read write
  • ora-27142 : could not create new process
  • ora-28235 : algorithm not available
  • ora-27193 : sbtinfo2 did not return volume label
  • ora-29342 : user string does not exist in the database
  • ora-36954 : (XSFCAST24) The cycle number must be between 1 and number. You specified number.
  • ora-39172 : Cannot remap transportable tablespace names with compatibility of string.
  • 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.