ORA-13218: max number of supported index tables reached for [string] index

Cause : An add_indxe parmaeterw as psased ot ALTRE INDXE whe nthe unmbero f exsitingi ndext able sis arleadya t maixmum.

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

Deleet oneo f th einde xtablse befroe adidng aontheri ndext able.

update : 27-04-2017

ORA-13218 - max number of supported index tables reached for [string] index
ORA-13218 - max number of supported index tables reached for [string] index

  • ora-38734 : Flashback log is inconsistent; belongs to another database.
  • ora-09352 : Windows 32-bit Two-Task driver unable to spawn new ORACLE task
  • ora-22976 : incorrect number of arguments to MAKE_REF
  • ora-12571 : TNS:packet writer failure
  • ora-13030 : Invalid dimension for the SDO_GEOMETRY object
  • ora-25107 : duplicate TABLESPACE option specification
  • ora-31029 : Cannot bind to unsaved resource
  • ora-39317 : call to DBMS_SCHEMA_COPY.VALIDATION_CHECK is not legal
  • ora-30189 : reserved for future use
  • ora-08453 : more than one V symbol specified in picture mask
  • ora-16239 : IMMEDIATE option not available without standby redo logs
  • ora-12827 : insufficient parallel query slaves available
  • ora-38952 : Source database not compatible
  • ora-07685 : sou2os: supervisor stack set error
  • ora-02191 : correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT
  • ora-24184 : transformation string.string already exists
  • ora-33046 : (XSAGDNGL22) In AGGMAP workspace object, you can specify only one SCREENBY clause.
  • ora-13777 : invalid list of attribute names
  • ora-16412 : ONDEMAND archival requires active SQL apply operation
  • ora-02252 : check constraint condition not properly ended
  • ora-13206 : internal error [string] while creating the spatial index
  • ora-07847 : sllfop: $CONNECT failure
  • ora-13614 : The template string is not compatible with the current advisor.
  • ora-30928 : Connect by filtering phase runs out of temp tablespace
  • ora-15065 : hash collision for diskgroup names 'string' and 'string'
  • ora-16041 : Remote File Server fatal error
  • ora-06930 : CMX: error when checking ORACLE_SID
  • ora-29325 : SET COMPATIBILITY release number lower than string
  • ora-16613 : initialization in progress for database
  • ora-12025 : materialized view log on "string"."string" already has primary keys
  • 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.