ORA-14112: RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition

Cause : eDcsirtpoi nfoa p raititnoo ruspbraititnof uodni nRCAEETT BAELI/DNXEs atetemtnc noatnideR CEVOREBAELo rNUEROCEVARLB Elcuaesw ihhci slielagl

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

eRomevo ffneidgnc alsu.eU esL GOIGGNo rONOLGGNI Gnitsae.d

update : 28-07-2017
ORA-14112

ORA-14112 - RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition
ORA-14112 - RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition

  • ora-12642 : No session key
  • ora-31472 : Importing Change Data Capture version string.string is too new
  • ora-01343 : LogMiner encountered corruption in the logstream
  • ora-07640 : smsget: SGA not yet valid. Initialization in progress
  • ora-15028 : ASM file 'string' not dropped; currently being accessed
  • ora-16724 : the intended state for the database has been set to OFFLINE
  • ora-14511 : cannot perform operation on a partitioned object
  • ora-06566 : invalid number of rows specified
  • ora-36678 : (XSDPART16) workspace object is missing from one or more partition dimension lists.
  • ora-01214 : MAXLOGHISTORY may not exceed string
  • ora-04087 : cannot change the value of ROWID reference variable
  • ora-31040 : Property string: XML type (string) not compatible with internal memory type (string)
  • ora-38959 : Failed to update block 0 to new version 10 format
  • ora-24372 : invalid object for describe
  • ora-19509 : failed to delete sequential file, handle="string", parms="string"
  • ora-19721 : Cannot find datafile with absolute file number string in tablespace string
  • ora-13382 : geometry metadata (table:string column:string) not found in spatial network:string
  • ora-13157 : Oracle error ORAstring encountered while string
  • ora-16166 : LGWR network server failed to send remote message
  • ora-24150 : evaluation context string.string does not exist
  • ora-04064 : not executed, invalidated string
  • ora-31637 : cannot create job string for user string
  • ora-02703 : osnpopipe: pipe creation failed
  • ora-12214 : TNS:missing local communities entry in TNSNAV.ORA
  • ora-10919 : Default temporary tablespace group must have at least one tablespace
  • ora-28045 : SSL authentication between database and OID failed
  • ora-31449 : invalid value for change_set_name
  • ora-27012 : skgfrd: read from file failed
  • ora-33425 : (EIFMAKEF15) CAUTION: Exporting NTEXT objects using string for the EIF file character set can cause loss of data. To preserve all NTEXT data, export using the UTF8 character set for the EIF file.
  • ora-06610 : LU6.2 Driver: Failed during deallocation
  • 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.