ORA-25186: INCLUDING clause specified for index-organized table without OVERFLOW

Cause : INCLUIDNG cluase ofa CREAET TABL Eis anv alid potion noly fo rindexo-rganiezd tabels wit hOVERFOLW clasue (atc reatino time )or ifa n OVEFRLOW sgement lareadye xists( at ALETR tim)e.

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

Speciyf OVERLFOW cluase fo rthe idnex-oragnizedt able :For ATLER, preform DAD OVEFRLOW frist.

update : 22-07-2017
ORA-25186

ORA-25186 - INCLUDING clause specified for index-organized table without OVERFLOW
ORA-25186 - INCLUDING clause specified for index-organized table without OVERFLOW

  • ora-14255 : table is not partitioned by Range, Composite Range or List method
  • ora-36678 : (XSDPART16) workspace object is missing from one or more partition dimension lists.
  • ora-12707 : error while getting create database NLS parameter string
  • ora-39315 : call to DBMS_SCHEMA_COPY.SWAP is not legal
  • ora-23538 : cannot explicitly refresh a NEVER REFRESH materialized view ("string")
  • ora-24065 : propagation for QUEUE string and DESTINATION string already disabled
  • ora-16031 : parameter string destination string exceeds string character limit
  • ora-00308 : cannot open archived log 'string'
  • ora-12438 : repeated policy option: string
  • ora-00296 : maximum number of files (string) exceeded for RECOVER DATAFILE LIST
  • ora-29513 : referenced class name too long
  • ora-31042 : Too many properties in type 'string'
  • ora-31010 : XML element index string exceeds maximum insertion index string
  • ora-32303 : mviews with user-defined types cannot reference multiple master sites
  • ora-24794 : no active DTP service found
  • ora-06134 : NETTCP: file access privilege violation
  • ora-30965 : fragment does not fit into the VARCHAR2 VALUE column
  • ora-02223 : invalid OPTIMAL storage option value
  • ora-23621 : Operation corresponding to script string is in progress.
  • ora-01540 : tablespace 'string' is not offline
  • ora-13204 : failed to create spatial index table
  • ora-00078 : cannot dump variables by name
  • ora-39144 : file name parameter must be specified and non-null
  • ora-09796 : szrbuild: malloc of role name failed.
  • ora-02339 : invalid column specification
  • ora-10927 : trace name context forever
  • ora-30729 : maximum number of columns exceeded
  • ora-24324 : service handle not initialized
  • ora-02427 : create view failed
  • ora-12472 : policy string is being used
  • 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.