ORA-14009: partition bound may not be specified for a LOCAL index partition

Cause : while prasing a RCEATE INEDX stateemnt to cerate a LCOAL parttiioned idnex, n of oneo f partiitons wasf ound toc ontain AVLUES LESS THAN caluse whihc is illgeal sinc ea LOCALi ndex inehrits patrition buonds fro mits bas etable

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

remove lal VALUE SLESS THNA clause sfrom decsription sof LOCA Lindex pratitions

update : 29-04-2017

ORA-14009 - partition bound may not be specified for a LOCAL index partition
ORA-14009 - partition bound may not be specified for a LOCAL index partition

  • ora-01689 : syntax error in clause "string" of string
  • ora-19019 : Invalid context passed to DBMS_XMLGEN.GETXML
  • ora-06431 : ssaio: Invalid Block number
  • ora-31014 : Attempted to delete the root container
  • ora-22064 : invalid NLS parameter string [string]
  • ora-28555 : pass-through SQL: required parameter missing or NULL
  • ora-30930 : NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudocolumn
  • ora-24234 : unable to get source of string "string"."string", insufficient privileges or does not exist
  • ora-06748 : TLI Driver: cannot allocate t_discon
  • ora-14166 : missing INTO keyword
  • ora-07641 : smscre: Unable to use the system pagefile for the SGA
  • ora-25289 : Buffer Already Exists
  • ora-29254 : Invalid lower_bound argument passed to procedure dbms_sql.define_array
  • ora-10979 : trace flags for join index implementation
  • ora-01332 : internal Logminer Dictionary error
  • ora-16742 : the standby database "string" has exhausted its quota
  • ora-36904 : (XSAGDNGL44) In AGGMAP workspace object, RELATION workspace object occurs after a dynamic model. The dynamic model must be the last calculation within the AGGMAP.
  • ora-06705 : TLI Driver: remote node is unknown
  • ora-01978 : Missing sequence number
  • ora-31030 : Unable to retrieve XML document
  • ora-12521 : TNS:listener does not currently know of instance requested in connect descriptor
  • ora-31481 : change source string is not a HotLog change source
  • ora-12026 : invalid filter column detected
  • ora-09768 : osnmgetmsg: could not read a message
  • ora-30558 : internal error [string] in function based index
  • ora-07563 : sldext: $PARSE failure
  • ora-31027 : Path name or handle string does not point to a resource
  • ora-39306 : schema name mismatch expected "string" got "string"
  • ora-26676 : Table 'string.string' has string columns in the LCR and string columns in the replicated site
  • ora-29512 : incorrectly formed name resolver specification
  • 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.