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 : 24-09-2017
ORA-14105

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

  • ora-00250 : archiver not started
  • ora-30397 : multiple JOIN KEY clauses specified for the same child level
  • ora-32322 : PCT refresh of "string"."string" not allowed the sequence of DMLs/PMOPs
  • ora-16796 : one or more properties could not be imported from the database
  • ora-24807 : LOB form mismatch
  • ora-07588 : spdcr: $GETJPIW get image name failure
  • ora-16588 : no more internal buffers
  • ora-25018 : conflicting trigger string already exists
  • ora-10615 : Invalid tablespace type for temporary tablespace
  • ora-02705 : osnpol: polling of communication channel failed
  • ora-24082 : propagation may still be happening for the schedule for QUEUE string and DESTINATION string
  • ora-28154 : Proxy user may not act as client 'string'
  • ora-32344 : cannot create a secondary materialized view with synonym as base table
  • ora-00226 : operation disallowed while alternate control file open
  • ora-02875 : smpini: Unable to get shared memory for PGA
  • ora-15198 : operation string is not yet available
  • ora-39956 : duplicate setting for PL/SQL compiler parameter string
  • ora-38458 : invalid operation "string" for XPATH_FILTER_PARAMETERS
  • ora-33215 : (CINSERT07) You cannot add session-only values to the workspace object dimension.
  • ora-07842 : sllfcl: SYS$CLOSE failure
  • ora-32511 : cannot create watchpoint in memory needed by watchpointing code
  • ora-30747 : cannot create substitutable tables or columns of non final type string.string
  • ora-01864 : the date is out of range for the current calendar
  • ora-27491 : repeat_interval and start_date cannot both be NULL
  • ora-00298 : Missing or invalid attribute value
  • ora-13465 : null or invalid table or column specification
  • ora-36678 : (XSDPART16) workspace object is missing from one or more partition dimension lists.
  • ora-02225 : only EXECUTE and DEBUG privileges are valid for procedures
  • ora-30733 : cannot specify rowid constraint on scoped ref column
  • ora-06764 : TLI Driver: error reading disconnect
  • 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.