ORA-10701: Dump direct loader index keys

Cause : Dumps index keys at various points in a direct load based on the value of this event.

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


update : 24-07-2017

ORA-10701 - Dump direct loader index keys
ORA-10701 - Dump direct loader index keys

  • ora-24091 : Destination queue string is the same as the source queue
  • ora-32590 : log group specification not allowed here
  • ora-32005 : error while parsing size specification [string]
  • ora-14509 : specified VALIDATE INTO table form incorrect
  • ora-01258 : unable to delete temporary file string
  • ora-00311 : cannot read header from archived log
  • ora-38621 : Decision Tree maximum depth setting not between [2, 20]
  • ora-25302 : Operation not possible for non-buffered queue string
  • ora-03290 : Invalid truncate command - missing CLUSTER or TABLE keyword
  • ora-32340 : cannot tune the materialized view definition
  • ora-29526 : created Java class string"string"
  • ora-07473 : snclrd: read error when trying to read sgadef.dbf file.
  • ora-31159 : XML DB is in an invalid state
  • ora-12341 : maximum number of open mounts exceeded
  • ora-16795 : database resource guard detects that database re-creation is required
  • ora-30740 : cannot grant UNDER privilege on this object
  • ora-31111 : table string cannot be hierarchically enabled
  • ora-19700 : device type exceeds maximum length of string
  • ora-29372 : identifier string is too long; it must be less than string characters
  • ora-24312 : illegal parameters specified for allocating user memory
  • ora-31121 : The string operator can not be FALSE
  • ora-39082 : Object type string created with compilation warnings
  • ora-31432 : invalid source table
  • ora-19033 : schema specified in the XML document does not match the schema parameter
  • ora-24388 : Unsupported functionality in fast path mode
  • ora-00354 : corrupt redo log block header
  • ora-29951 : warning in the execution of ODCIINDEXSPLITPARTITION routine
  • ora-12423 : invalid position specified
  • ora-30044 : 'Retention' can only specified for undo tablespace
  • ora-24232 : unknown Embedded PL/SQL Gateway attribute string
  • 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.