ORA-04078: OLD and NEW values cannot be identical

Cause : The refreencing lcause spceifies iedntical avlues fo rNEW andO LD.

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

Re-specfiy eithe rthe OLDo r NEW rfeerencin gvalue.

update : 26-06-2017

ORA-04078 - OLD and NEW values cannot be identical
ORA-04078 - OLD and NEW values cannot be identical

  • ora-23515 : materialized views and/or their indices exist in the tablespace
  • ora-16554 : translation not valid
  • ora-22317 : typecode number is not legal as a number type
  • ora-22153 : source variable-length array is not initialized
  • ora-23388 : replication parallel push watermark error
  • ora-38709 : Recovery Area is not enabled.
  • ora-29859 : error occurred in the execution of ODCIINDEXTRUNCATE routine
  • ora-09745 : smscre: vm_allocate error, unable to create shared memory.
  • ora-12712 : new character set must be a superset of old character set
  • ora-12544 : TNS:contexts have different wait/test functions
  • ora-29338 : datafile string is in an undesired state (string, string)
  • ora-30396 : rewrite equivalence procedures require the COMPATIBLE parameter to be string or greater
  • ora-06817 : TLI Driver: could not read the Novell network address
  • ora-27548 : Unable to unprepare IPC buffer
  • ora-07260 : spdcr: wait error.
  • ora-25240 : message ID and dequeue condition/correlation ID specified in dequeue options
  • ora-25437 : duplicate table value for table alias: string
  • ora-09263 : spini: error initializing process
  • ora-14168 : only one subpartition may be modified
  • ora-39048 : Unable to start all workers; only string worker(s) available.
  • ora-31511 : name exceeds maximum length of 30 characters
  • ora-27050 : function called with invalid FIB/IOV structure
  • ora-08318 : sllfsk: Error reading file
  • ora-32606 : missing NAV keyword in MODEL clause
  • ora-01526 : error in opening file 'string'
  • ora-09272 : remote os logon is not allowed
  • ora-16150 : FINISH recovery performed on another, older standby database
  • ora-02083 : database name has illegal character 'string'
  • ora-26508 : null materialized view connection
  • ora-13205 : internal error while parsing spatial parameters
  • 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.