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-05-2017

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

  • ora-19716 : error processing format string to generate name for backup
  • ora-07641 : smscre: Unable to use the system pagefile for the SGA
  • ora-01188 : Block size string in header does not match physical block size string
  • ora-39704 : permission to modify component registry entry denied
  • ora-00470 : LGWR process terminated with error
  • ora-30454 : summary contains STDDEV without corresponding SUM & COUNT
  • ora-38706 : Cannot turn on FLASHBACK DATABASE logging.
  • ora-24037 : schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE
  • ora-00701 : object necessary for warmstarting database cannot be altered
  • ora-28119 : policy group does not exist
  • ora-14161 : subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100
  • ora-32584 : missing LOG keyword
  • ora-01934 : circular role grant detected
  • ora-23392 : could not find materialized view to be associated with "string"."string"
  • ora-12734 : Instant Client Light: unsupported client national character set string
  • ora-23367 : table string is missing the primary key
  • ora-19590 : conversation already active
  • ora-30021 : Operation not allowed on undo tablespace
  • ora-07572 : szrfc: insufficient rolename buffer space
  • ora-38461 : XML Tag "string" already exists for the XMLType attribute "string"
  • ora-24505 : cannot change character set id on the handle
  • ora-13015 : the window definition is not valid
  • ora-30515 : suspend triggers cannot have BEFORE type
  • ora-32120 : Buffer size is less than amount specified
  • ora-02255 : obsolete 7.1.5
  • ora-30060 : Internal event for RECO tracing
  • ora-25467 : table alias not specified
  • ora-30077 : illegal casting between specified datetime types
  • ora-29302 : database is not open clone
  • ora-32035 : unreferenced query name defined in WITH clause
  • 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.