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-07-2017

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

  • ora-00152 : current session does not match requested session
  • ora-13303 : failure to retrieve a geometry object from a table
  • ora-02453 : duplicate HASH IS specification
  • ora-02397 : exceeded PRIVATE_SGA limit, you are being logged off
  • ora-12169 : TNS:Net service name given as connect identifier is too long
  • ora-14129 : INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints
  • ora-23444 : duplicate template parameter
  • ora-19124 : fn:one-or-more() called with a sequence containing no items
  • ora-38452 : Expression Filter index name may not be longer than 25 characters
  • ora-30016 : undo tablespace 'string' is already in use by this instance
  • ora-19688 : control file autobackup format(string) for string does not have %F
  • ora-29323 : ALTER DATABASE SET COMPATIBILITY command not supported by string
  • ora-01942 : IDENTIFIED BY and EXTERNALLY cannot both be specified
  • ora-19377 : no "SQL Tuning Set" with name like "string" exists for owner like "string"
  • ora-07405 : sptrap: cannot setup alternate signal stack.
  • ora-06763 : TLI Driver: error sending disconnect
  • ora-07244 : ssfccf: create file failed, file size limit reached.
  • ora-00356 : inconsistent lengths in change description
  • ora-01208 : data file is an old version - not accessing current version
  • ora-10562 : Error occurred while applying redo to data block (file# string, block# string)
  • ora-01508 : cannot create database; error in file 'string' at line string
  • ora-16411 : ONDEMAND archival requires active managed recovery operation
  • ora-32126 : Cannot perform operations on a null REF
  • ora-16046 : Archive log destination failed due to failed dependent destination
  • ora-28173 : certificate not provided by proxy
  • ora-36668 : (XSDPART06) string is not a legal RANGE partition.
  • ora-09241 : smsalo: error allocating SGA memory
  • ora-23329 : successful user-provided ddl but no materialized view "string"."string"
  • ora-01417 : a table may be outer joined to at most one other table
  • ora-38758 : cannot flashback data file string; restored since last recovery
  • 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.