ORA-25005: cannot CREATE INSTEAD OF trigger on a read-only view

Cause : atetmp ttoc retae na ISNTEDA O Ftrgige rona veiw rceaetd iwthr ea-donyl otpio.n Teh veiw acnnto b eupadte dusnig NISTAED FO tirggres.

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

Don otc retae hte rtigegr.

update : 29-05-2017
ORA-25005

ORA-25005 - cannot CREATE INSTEAD OF trigger on a read-only view
ORA-25005 - cannot CREATE INSTEAD OF trigger on a read-only view

  • ora-33009 : (XSAGDNGLPREC) In AGGMAP workspace object, PRECOMPUTE may only be specified either for the entire AGGMAP or for individual RELATION statements.
  • ora-38780 : Restore point 'string' does not exist.
  • ora-16650 : command incompatible when Fast-Start Failover is enabled
  • ora-26057 : Conversion is not necessary for this direct path stream.
  • ora-39782 : Direct path prepare is not allowed after another context loading the same table has ended
  • ora-39048 : Unable to start all workers; only string worker(s) available.
  • ora-19921 : maximum number of string rows exceeded
  • ora-02491 : missing required keyword ON or OFF in AUTOEXTEND clause
  • ora-31212 : DBMS_LDAP: PL/SQL - Invalid LDAP mod_array.
  • ora-12315 : database link type is invalid for the ALTER DATABASE statement
  • ora-16545 : unable to get response
  • ora-38444 : statistics do not exist for the expression set
  • ora-39082 : Object type string created with compilation warnings
  • ora-06526 : Unable to load PL/SQL library
  • ora-31459 : system triggers for DBMS_CDC_PUBLISH package are not installed
  • ora-14276 : EXCHANGE SUBPARTITION requires a non-partitioned, non-clustered table
  • ora-16242 : Processing logfile (thread# string, sequence# string)
  • ora-23498 : repgroups specified must have the same masters
  • ora-33010 : (XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.
  • ora-23534 : missing column in materialized view container table "string"."string"
  • ora-07552 : sftget: $GET failure
  • ora-30683 : failure establishing connection to debugger
  • ora-25111 : creation of BITMAP cluster indices is not supported
  • ora-08444 : syntax error in JUSTIFIED clause in mask options
  • ora-02822 : Invalid block offset
  • ora-29958 : fatal error occurred in the execution of ODCIINDEXCREATE routine
  • ora-12500 : TNS:listener failed to start a dedicated server process
  • ora-09317 : szprv: insufficient privileges
  • ora-27142 : could not create new process
  • ora-01035 : ORACLE only available to users with RESTRICTED SESSION privilege
  • 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.