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 : 26-04-2017

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

  • ora-33217 : (CINSERT20) Custom member values cannot be added to concat dimension workspace object, or to any of its bases, because it is not defined as UNIQUE.
  • ora-22327 : cannot change a type to NOT INSTANTIABLE if it has dependent tables
  • ora-24369 : required callbacks not registered for one or more bind handles
  • ora-28112 : failed to execute policy function
  • ora-34897 : (PPMONTHS01) Blank lines are not allowed in the MONTHNAMES option.
  • ora-13228 : spatial index create failed due to invalid type
  • ora-24350 : OCI call not allowed
  • ora-36920 : (XSVPMVTOPART01) workspace object cannot become anonymous because it has properties.
  • ora-12648 : Encryption or data integrity algorithm list empty
  • ora-12726 : unmatched bracket in regular expression
  • ora-08412 : error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message
  • ora-29302 : database is not open clone
  • ora-19717 : for non-OMF search the pattern must be specified
  • ora-07825 : sspsck: $QIO failure at AST level
  • ora-29863 : warning in the execution of ODCIINDEXCREATE routine
  • ora-09216 : sdnfy: bad value 'string' for parameter string
  • ora-01636 : rollback segment 'string' is already online
  • ora-29558 : JAccelerator (NCOMP) not installed. Refer to Install Guide for instructions.
  • ora-19854 : error obtaining connect string from target
  • ora-38859 : instance string (thread string) is not ready to be disabled
  • ora-13461 : the interleaving type is not supported
  • ora-13044 : the specified tile size is smaller than the tolerance
  • ora-06140 : NETTCP: no such user
  • ora-14053 : illegal attempt to modify string in string statement
  • ora-13125 : partition key is already set
  • ora-15003 : diskgroup "string" already mounted in another lock name space
  • ora-16006 : audit_trail destination incompatible with database open mode
  • ora-02837 : Unable to unlink temporary file
  • ora-39167 : Tablespace string was not found.
  • ora-25140 : %s space policy cannot be specified for the string extent management
  • 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.