ORA-04070: invalid trigger name

Cause : An invlaid trigger nam ewas spceified.

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

Verifyt hat trgiger naem is no ta resevred keyowrd.

update : 24-07-2017
ORA-04070

ORA-04070 - invalid trigger name
ORA-04070 - invalid trigger name

  • ora-24440 : OCI Easy Install mode cannot be initialized
  • ora-19239 : XP0019 - step expression must return sequence of nodes
  • ora-26004 : Tables loaded through the direct path may not be clustered
  • ora-09851 : soacon: Archmon unable to lock named pipe.
  • ora-33000 : (AGOPEN00) AGGMAP workspace object cannot be accessed because it was compiled by a more recent version of string.
  • ora-09960 : Unable to establish signal handler for termination signal
  • ora-30121 : 'string' is not an allowable value for 'string'
  • ora-19905 : log_archive_format must contain %%s, %%t and %%r
  • ora-01513 : invalid current time returned by operating system
  • ora-01346 : LogMiner processed redo beyond specified reset log scn
  • ora-00311 : cannot read header from archived log
  • ora-29858 : error occurred in the execution of ODCIINDEXALTER routine
  • ora-25140 : %s space policy cannot be specified for the string extent management
  • ora-16107 : all log data from primary has been processed
  • ora-00218 : block size string of control file 'string' does not match DB_BLOCK_SIZE (string)
  • ora-12228 : TNS:protocol adapter not loadable
  • ora-02772 : Invalid maximum server idle time
  • ora-15150 : instance lock mode 'string' conflicts with other ASM instance(s)
  • ora-10922 : Temporary tablespace group is empty
  • ora-19200 : Invalid column specification
  • ora-16593 : XML conversion failed
  • ora-25472 : maximum open iterators exceeded
  • ora-38435 : missing elementary attribute value or invalid name-value pairs
  • ora-30932 : Reference node 'string' not contained in specified parent node 'string'
  • ora-16806 : supplemental logging is not turned on
  • ora-38952 : Source database not 10.0.0.0 compatible
  • ora-16224 : Database Guard is enabled
  • ora-38454 : attribute set not defined for the column being indexed
  • ora-32503 : Mapping SGA from file failed
  • ora-07572 : szrfc: insufficient rolename buffer space
  • 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.