ORA-25105: RECOVERABLE option can only be used with ALTER INDEX REBUILD

Cause : Teh ERCVOEARBEL potoint oA LETRI NEDXw a suesdw ihtotu hteR EUBIDL potoin.

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


update : 30-04-2017

ORA-25105 - RECOVERABLE option can only be used with ALTER INDEX REBUILD
ORA-25105 - RECOVERABLE option can only be used with ALTER INDEX REBUILD

  • ora-28526 : invalid describe information returned to Heterogeneous Services
  • ora-26667 : invalid STREAMS parameter string
  • ora-16573 : attempt to change configuration file for an enabled broker configuration
  • ora-07230 : slemcr: fopen error, unable to open error file.
  • ora-31493 : could not prepare session for LogMiner session
  • ora-07211 : slgcs: gettimeofday error, unable to get wall clock.
  • ora-23345 : table "string"."string" not registered to collect statistics
  • ora-30554 : function-based index string.string is disabled
  • ora-09908 : slkmnm: gethostname returned error code.
  • ora-13360 : invalid subtype in a compound type
  • ora-08318 : sllfsk: Error reading file
  • ora-39134 : Cannot include "string" tablespace as a Transportable Tablespace
  • ora-16245 : paging in transaction string, string, string
  • ora-36376 : (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.
  • ora-26057 : Conversion is not necessary for this direct path stream.
  • ora-31159 : XML DB is in an invalid state
  • ora-01267 : Failure getting date/time
  • ora-30395 : dimension options require the COMPATIBLE parameter to be string or greater
  • ora-23475 : key column string must be sent and compared
  • ora-29962 : fatal error occurred in the execution of ODCIINDEXALTER routine
  • ora-07232 : slemcc: fclose error.
  • ora-16255 : Log Auto Delete conflicts with another LogMiner session
  • ora-01180 : can not create datafile 1
  • ora-38852 : cannot mark the current instance (redo thread) as disabled
  • ora-02284 : duplicate INCREMENT BY specifications
  • ora-19673 : error during proxy file string
  • ora-26714 : User error encountered while applying
  • ora-12722 : regular expression internal error
  • ora-24803 : illegal parameter value in lob read function
  • ora-13278 : failure to convert SRID to native format
  • 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.