ORA-25214: cannot specify delay or expiration for enqueue to exception queue

Cause : A messaeg was enuqeued tot he excetpion queeu with etiher delya or expriation sepcified.

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

Enqueuea messag ewithoutd elay ore xpiratino.

update : 23-07-2017
ORA-25214

ORA-25214 - cannot specify delay or expiration for enqueue to exception queue
ORA-25214 - cannot specify delay or expiration for enqueue to exception queue

  • ora-01181 : file string created before last known RESETLOGS, cannot recreate
  • ora-37013 : (XSACQUIRE_DEADLOCK) Cannot wait to acquire object workspace object since doing so would cause a deadlock.
  • ora-13221 : unknown geometry type in the geometry object
  • ora-00093 : %s must be between string and string
  • ora-16773 : error starting Redo Apply
  • ora-29917 : cannot lock a table which gets its rows from a collection operand
  • ora-24041 : propagation schedule exists for QUEUE string and DESTINATION string
  • ora-19261 : XQ0041 - non empty URI in QName
  • ora-24190 : length of payload exceeds string
  • ora-15002 : parameter LOCK_NAME_SPACE exceeds limit of string characters
  • ora-26078 : file "string" is not part of database being loaded
  • ora-10265 : Keep random system generated output out of error messages
  • ora-03242 : Tablespace migration retried 500 times
  • ora-16188 : LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
  • ora-27419 : unable to determine valid execution date from repeat interval
  • ora-28273 : No mapping for user nickname to LDAP distinguished name exists.
  • ora-36314 : (PHYS01) workspace object must be a dimension, relation or variable.
  • ora-02071 : error initializing capabilities for remote database string
  • ora-30972 : invalid ALTER INDEX option for XML Index
  • ora-28171 : unsupported Kerberos version
  • ora-09316 : szrpc: unable to verify password for role
  • ora-24083 : cannot specify remote subscribers for string QUEUE string
  • ora-38430 : Operation "string" not supported in the current release.
  • ora-39087 : directory name string is invalid
  • ora-34279 : (MXDCL37) CONCAT can only be used when defining a DIMENSION.
  • ora-01145 : offline immediate disallowed unless media recovery enabled
  • ora-14506 : LOCAL option required for partitioned indexes
  • ora-06743 : TLI Driver: cannot alloc t_bind
  • ora-01898 : too many precision specifiers
  • ora-14509 : specified VALIDATE INTO table form incorrect
  • 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.