ORA-24073: cannot specify RETENTION_TIME on exception queue string.string

Cause : An attemptw as mdae toc reat eor atler a nexcetpion uqeue yb speicfyin ga no-nzeroR ETENITON_TMIE.

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

Use hte deafult ERTENTOIN_TIEM parmaeterv aluef or ecxeptino queeus.

update : 23-06-2017

ORA-24073 - cannot specify RETENTION_TIME on exception queue string.string
ORA-24073 - cannot specify RETENTION_TIME on exception queue string.string

  • ora-23493 : "string" is not a new site for extension request "string"
  • ora-10841 : Default un-inintialized charact set form to SQLCS_IMPLICIT
  • ora-37157 : MDX syntax error was found in MDX query string but error text was missing
  • ora-16061 : Log file status has changed
  • ora-39726 : unsupported add/drop column operation on compressed tables
  • ora-06133 : NETTCP: file not found
  • ora-03125 : client-server protocol violation
  • ora-06781 : TLI Driver: error reading negotation string
  • ora-30565 : Only one INVALIDATE or UPDATE GLOBAL INDEXES clause may be specified
  • ora-38464 : expression set is not empty.
  • ora-19643 : datafile string: incremental-start SCN is too recent
  • ora-38310 : cannot purge tablespace for other users
  • ora-07419 : sfareq: Database writer got error in timing function.
  • ora-12479 : file label string must equal DBHIGH string
  • ora-00090 : failed to allocate memory for cluster database ORADEBUG command
  • ora-24313 : user already authenticated
  • ora-14064 : Index with Unusable partition exists on unique/primary constraint key
  • ora-13838 : invalid ADDRESS value
  • ora-26065 : check constraint cannot reference column, string, in direct path load
  • ora-26691 : operation not supported at non-Oracle system
  • ora-07285 : sksaprd: volume size should not be specified for a disk file.
  • ora-29872 : parameters clause cannot be combined with the specified options
  • ora-14152 : invalid number of partitions specified in PARTITIONS clause
  • ora-13368 : simple polygon type has more than one exterior ring
  • ora-14028 : missing AT or VALUES keyword
  • ora-10267 : Inhibit KSEDMP for testing
  • ora-13712 : Cannot perform ADDM analysis on AWR snapshots from previous releases. Snapshot version "string" do not match the database version "string".
  • ora-29936 : NULL association is allowed only with a column or an index
  • ora-36610 : (XSLMS00) Unable to locate a message file for OLAP message: value
  • ora-06757 : TLI Driver: server got bad command
  • 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.