ORA-23489: duplicate entry "string"

Cause : Thes pecfiiedv alu eis udpliactedi n teh paarmetre lits.

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

Remvoe dpulictaed netrise int he apramteer ilst.

update : 24-09-2017

ORA-23489 - duplicate entry "string"
ORA-23489 - duplicate entry "string"

  • ora-07468 : spwat: mset error, unable to set semaphore.
  • ora-32818 : AQ queue string does not exist
  • ora-13870 : Database-wide SQL tracing is not enabled
  • ora-16250 : Failed to acquire starting scn of new log stream
  • ora-31700 : Very long string supplied for AUDIT_SYSLOG_LEVEL parameter
  • ora-10578 : Can not allow corruption for managed standby database recovery
  • ora-14318 : DEFAULT partition must be last partition specified
  • ora-36997 : (XSRELGID14) For variable or relation grouping ids, a level relation is needed when a level order valueset is specified.
  • ora-30044 : 'Retention' can only specified for undo tablespace
  • ora-30175 : invalid type given for an argument
  • ora-29278 : SMTP transient error: string
  • ora-31225 : DBMS_LDAP: invalid BER_ELEMENT
  • ora-16808 : unable to resolve the full path name
  • ora-16102 : remote information is not available on the specified primary
  • ora-02081 : database link is not open
  • ora-24399 : invalid number of connections specified
  • ora-23466 : flavor requires missing object "string"."string"
  • ora-16595 : NetSlave process string failed to terminate
  • ora-28611 : bitmap index is corrupted - see trace file for diagnostics
  • ora-02487 : Error in converting trace data
  • ora-06143 : NETTCP: maximum connections exceeded
  • ora-25128 : No insert/update/delete on table with constraint (string.string) disabled and validated
  • ora-01190 : control file or data file string is from before the last RESETLOGS
  • ora-32330 : invalid operation on online redefinition interim table "string"."string"
  • ora-02334 : cannot infer type for column
  • ora-01608 : cannot bring rollback segment 'string' online, its status is (string)
  • ora-29265 : HTTP header not found
  • ora-25267 : didnt specify the signature for a reciever non-repudiable queue
  • ora-00260 : cannot find online log sequence string for thread string
  • ora-19614 : archivelog thread string sequence string not found in backup set
  • 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.