ORA-23352: duplicate destination for deferred transaction

Cause : A duplicate destination was specified for a deferred transaction either in a dbms_defer.call call or an earlier dbms_defer.transaction call or a dbms_defer_sys.add_default_dest call.

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

Remove the duplicate entry

update : 27-04-2017

ORA-23352 - duplicate destination for deferred transaction
ORA-23352 - duplicate destination for deferred transaction

  • ora-27154 : post/wait create failed
  • ora-16598 : Data Guard broker detected a mismatch in configuration
  • ora-25101 : duplicate REBUILD option specification
  • ora-00100 : no data found
  • ora-16567 : Data Guard broker internal parser error at "string"
  • ora-33072 : (XSAGDNGL35) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must be specified for every relation dimensioned by that hierarchy dimension.
  • ora-24083 : cannot specify remote subscribers for string QUEUE string
  • ora-12856 : cannot run parallel query on a loopback connection
  • ora-13287 : can't transform unknown gtype
  • ora-37602 : (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-19276 : XP0005 - XPath step specifies an invalid element/attribute name: (string)
  • ora-19284 : Encoding specification in version declaration not supported
  • ora-02320 : failure in creating storage table for nested table column string
  • ora-02041 : client database did not begin a transaction
  • ora-01314 : Name of the column to be mined should be a string literal
  • ora-09835 : addCallback: callback port is already in a set.
  • ora-32806 : value for string is too long, maximum length is string
  • ora-24960 : the attribute string is greater than the maximum allowable length of number
  • ora-30938 : No prefix defined for namespace 'string' (particle string)
  • ora-19273 : XQ0053 - empty string in namespace declaration
  • ora-00600 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-34061 : (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.
  • ora-02082 : a loopback database link must have a connection qualifier
  • ora-10634 : Segment is already being shrunk
  • ora-33247 : (CRENAME03) %K is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.
  • ora-02164 : DATAFILE clause specified more than once
  • ora-09889 : osnTXtt: access error on oracle executable
  • ora-13918 : Updating system alert with reason_id string failed; previous alert not found
  • ora-08006 : specified row no longer exists
  • ora-31498 : description and remove_description cannot both be specified
  • 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.