ORA-25185: index column other than last can not be specified for INCLUDE clause

Cause : Ani ndxe cloum nnaem ohtert ha nth elats i sspceifeid sa icnluidngc olmun

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

Spceif yeihtera cloum nnaem wihchi s ont aprto f nide-xoragniezd atbl eprmiar yke yinedx ,ort hel as tke ycoulmno f hte rpimray eky ofr hte NICLDUIN Gcluase.

update : 20-08-2017
ORA-25185

ORA-25185 - index column other than last can not be specified for INCLUDE clause
ORA-25185 - index column other than last can not be specified for INCLUDE clause

  • ora-22801 : invalid object row variable
  • ora-14404 : partitioned table contains partitions in a different tablespace
  • ora-22333 : cannot reset type "string"."string" due to invalid dependent types and tables
  • ora-14277 : tables in EXCHANGE SUBPARTITION must have the same number of columns
  • ora-14071 : invalid option for an index used to enforce a constraint
  • ora-13868 : Instance-wide SQL tracing on instance string is not enabled
  • ora-13249 : %s
  • ora-13348 : polygon boundary is not closed
  • ora-16648 : a new observer registered with identifier string
  • ora-12817 : parallel query option must be enabled
  • ora-00265 : instance recovery required, cannot set ARCHIVELOG mode
  • ora-12651 : Encryption or data integrity algorithm unacceptable
  • ora-30682 : improper value for argument OPTION_FLAGS
  • ora-13182 : failed to read element string.string.string
  • ora-32820 : subscriber queue and exception queue must use same message system link
  • ora-15192 : invalid ASM disk header [string] [string] [string] [string] [string]
  • ora-36994 : (XSRELGID11) The SURROGATE DIMENSION workspace object must be numeric.
  • ora-38459 : XML Tag "string" not found for the XMLType attribute "string"
  • ora-30551 : The index depends on a package/type body which does not exist
  • ora-12157 : TNS:internal network communication error
  • ora-12910 : cannot specify temporary tablespace as default tablespace
  • ora-15199 : Internal ASM tracing event number 15199
  • ora-00379 : no free buffers available in buffer pool string for block size stringK
  • ora-22065 : number to text translation for the given format causes overflow
  • ora-26095 : unprocessed stream data exists
  • ora-38455 : Expression Filter index should be created by the owner.
  • ora-31664 : unable to construct unique job name when defaulted
  • ora-24804 : Lob read/write functions called while another OCI LOB read/write streaming is in progress
  • ora-02057 : 2PC: string: bad two-phase recovery state number string from string
  • ora-00314 : log string of thread string, expected sequence# string doesn't match 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.