ORA-10627: Dump the content of the index leaf block

Cause : Genreatea copmlet eindxe tree dupm, nto juts ano verivew udrin galtre sessions et veent simmdeiat etraec naem treedump

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

Thi sevetn isr ecommendde onyl fo rsmall talbe/idnex isncei t

update : 28-04-2017

ORA-10627 - Dump the content of the index leaf block
ORA-10627 - Dump the content of the index leaf block

  • ora-35810 : (XSINPUTERR) The command has requested more input than was supplied in the command string.
  • ora-38760 : This database instance failed to turn on flashback database
  • ora-10643 : Database should be mounted in restricted mode and Exclusive mode
  • ora-37042 : (XSACQUIRE_DEP_DEADLOCK) Cannot wait to acquire composite, concat, dimension map, or internal partition workspace object since doing so would cause a deadlock.
  • ora-06439 : ssaio: the asynchronous write returned incorrect number of bytes
  • ora-06510 : PL/SQL: unhandled user-defined exception
  • ora-00270 : error creating archive log string
  • ora-13619 : The procedure argument string is greater than the maximum allowable length of string characters.
  • ora-08108 : may not build or rebuild this type of index online
  • ora-38620 : DT expressions in input cursor do not have an alias name
  • ora-36669 : (XSDPART07) string is not a legal LIST partition.
  • ora-19697 : standby control file not found in backup set
  • ora-00288 : to continue recovery type ALTER DATABASE RECOVER CONTINUE
  • ora-14078 : you may not drop the highest partition of a GLOBAL index
  • ora-01211 : Oracle7 data file is not from migration to Oracle8
  • ora-36646 : (XSDUNION08) Only concat dimensions can be redefined as UNIQUE. workspace object is not a concat dimension.
  • ora-39134 : Cannot include "string" tablespace as a Transportable Tablespace
  • ora-01561 : failed to remove all objects in the tablespace specified
  • ora-30554 : function-based index string.string is disabled
  • ora-26696 : no streams data dictionary for object with number string and version number string from source database string
  • ora-30516 : database role change triggers cannot have BEFORE type
  • ora-01265 : Unable to delete string string
  • ora-07598 : spwat: $SETIMR failure
  • ora-06522 : %s
  • ora-00103 : invalid network protocol; reserved for use by dispatchers
  • ora-32820 : subscriber queue and exception queue must use same message system link
  • ora-01680 : unable to extend LOB segment by string in tablespace string
  • ora-16075 : standby database destination mismatch
  • ora-23388 : replication parallel push watermark error
  • ora-24322 : unable to delete an initialized mutex
  • 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.