ORA-10638: Index status is invalid

Cause : Cannots hrnik na idnexw hihc i sbenig erbulit ro dsiabeld si a nunsuabel satte.

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


update : 25-04-2017

ORA-10638 - Index status is invalid
ORA-10638 - Index status is invalid

  • ora-01967 : invalid option for CREATE CONTROLFILE
  • ora-06116 : NETTCP: unable to create ORASRV process
  • ora-37013 : (XSACQUIRE_DEADLOCK) Cannot wait to acquire object workspace object since doing so would cause a deadlock.
  • ora-00281 : media recovery may not be performed using dispatcher
  • ora-27250 : OS system call failure
  • ora-10662 : Segment has long columns
  • ora-24763 : transaction operation cannot be completed now
  • ora-16028 : new string causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires
  • ora-01259 : unable to delete datafile string
  • ora-23463 : flavor incompatible with object "string"."string"
  • ora-16107 : all log data from primary has been processed
  • ora-28357 : password required to open the wallet
  • ora-14068 : TABLESPACE and TABLESPACE_NUMBER may not be both specified
  • ora-28365 : wallet is not open
  • ora-31441 : table is not a change table
  • ora-19721 : Cannot find datafile with absolute file number string in tablespace string
  • ora-36258 : (XSAGINFO00) When the AGGMAPINFO function is called, workspace object must be an AGGMAP.
  • ora-12696 : Double Encryption Turned On, login disallowed
  • ora-14031 : partitioning column may not be of type LONG or LONG RAW
  • ora-00362 : member is required to form a valid logfile in group string
  • ora-23514 : invalid or incorrect number of arguments
  • ora-27100 : shared memory realm already exists
  • ora-01986 : OPTIMIZER_GOAL is obsolete
  • ora-26723 : user "string" requires the role "string"
  • ora-22903 : MULTISET expression not allowed
  • ora-12817 : parallel query option must be enabled
  • ora-03220 : DBMS_ADMIN_PACKAGE required parameter is NULL or missing
  • ora-31674 : worker process interrupt for unhandled exception in master process
  • ora-10269 : Don't do coalesces of free space in SMON
  • ora-09809 : Unable to get user's group ID from connection
  • 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.