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 : 26-09-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-28660 : Partitioned Index-Organized table may not be MOVEd as a whole
  • ora-14309 : Total count of list values exceeds maximum allowed
  • ora-08191 : Flashback Table operation is not supported on remote tables
  • ora-25254 : time-out in LISTEN while waiting for a message
  • ora-39166 : Object string was not found.
  • ora-13275 : spatial index creation failure on unsupported type
  • ora-01923 : CASCADE aborted, objects locked by another user
  • ora-39201 : Dump files are not supported for estimate only jobs.
  • ora-00439 : feature not enabled: string
  • ora-38502 : invalid XML tag: string
  • ora-01279 : db_files too large
  • ora-13830 : SQL profile with category string already exists for this SQL statement
  • ora-09200 : sfccf: error creating file
  • ora-09774 : osnmui: cannot send break message
  • ora-26508 : null materialized view connection
  • ora-16713 : the resource guard timed out while servicing the request
  • ora-38952 : Source database not 10.0.0.0 compatible
  • ora-09758 : osnipn: could not check port in name server.
  • ora-14175 : a subpartition maintenance operation may not be combined with other operations
  • ora-03264 : cannot drop offline datafile of locally managed tablespace
  • ora-06545 : PL/SQL: compilation error - compilation aborted
  • ora-16151 : Managed Standby Recovery not available
  • ora-30340 : illegal dimension name
  • ora-16195 : DG_CONFIG requires DB_UNIQUE_NAME be explicitly defined
  • ora-24070 : cannot upgrade queue table string while it is being downgraded
  • ora-24785 : Cannot resume a non-migratable transaction
  • ora-21703 : cannot flush an object that is not modified
  • ora-16768 : SQL Apply unexpectedly offline
  • ora-39132 : object type "string"."string" already exists with different hashcode
  • ora-36206 : (XSAGOP04R) In AGGMAP workspace object, REMOPERATOR string must be MIN, MAX, FIRST, LAST, HFIRST or HLAST.
  • 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.