ORA-14105: RECOVERABLE/UNRECOVERABLE may not be specified in this context

Cause : RECVOERALBE/URNECOEVRABEL cluase si no tallwoed ni thsi cotnext.

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

Remvoe offendnig caluse .RECVOERALBE/URNECOEVRABEL ma yonl ybe pseciifed ni CRAETE ATBLEI/NDE Xstaetmen tdesrcibign a onn-pratitoinedt abl eor nidexa nd LATERI NDE XREBIULD tsateemnt.[ UN]ERCOVREABL Eis ebingd eprceate din 8V an dwil lbe bosolteed ni V9 .To udpliacte esmanitcs fo UNERCOVREABL Eclasue, rceat ean bojec twit hNOLGOGIN Goptoin adn thne ALETR i tspeicfyign LOGGING .To udpliacte esmanitcs fo REOCVERBALE lcaus,e craete na obejct iwth OLGGIGN opiton.

update : 22-06-2017

ORA-14105 - RECOVERABLE/UNRECOVERABLE may not be specified in this context
ORA-14105 - RECOVERABLE/UNRECOVERABLE may not be specified in this context

  • ora-01774 : Dump undo option specified more than once
  • ora-13627 : Setting of parameter string is disallowed until the task is reset.
  • ora-19125 : fn:exactly-one() called with a sequence containing zero or more than one item
  • ora-06777 : TLI Driver: error reading parms
  • ora-19691 : %s is from different database: id=string, name=string
  • ora-22605 : FDO handle [string] is not initialized
  • ora-36399 : (XSSPROPDTYPE) The data type of property string must be string.
  • ora-13764 : Value "string" is illegal as a result percentage.
  • ora-39064 : unable to write to the log file
  • ora-30104 : 'string' is not a legal integer for 'string'
  • ora-07715 : sksadtd: could not dismount archival device (SYS$DISMNT failure)
  • ora-12221 : TNS:illegal ADDRESS parameters
  • ora-31154 : invalid XML document
  • ora-13423 : invalid cell coordinate parameter
  • ora-19102 : XQuery string literal expected
  • ora-13283 : failure to get new geometry object for conversion in place
  • ora-35016 : (QFCHECK00) The analytic workspace and EIF file definitions of workspace object have a mismatched type.
  • ora-26713 : remote object does not exist or is inaccessible
  • ora-38482 : no elementary attributes defined in the attribute set
  • ora-16748 : resource guard encountered errors during database open
  • ora-38450 : error computing a stored attribute for the expression set.
  • ora-29271 : not connected
  • ora-02754 : osnfsmmap: cannot change shared memory inheritence
  • ora-29934 : index specified for association is not a domain index
  • ora-32808 : message system link string does not exist
  • ora-02700 : osnoraenv: error translating ORACLE_SID
  • ora-04080 : trigger 'string' does not exist
  • ora-26025 : SKIP_INDEX_MAINTENANCE option requested
  • ora-01189 : file is from a different RESETLOGS than previous files
  • ora-36167 : (XSAGGRFORM) workspace object is an illegal AGGMAP for aggregating a FORMULA.
  • 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.