ORA-13231: failed to create index table [string] during R-tree creation

Cause : The specified index table either already exists or there is not enough tablespace.

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

Delete the table if it already exists and verify if the current user has CREATE TABLE privileges and has sufficient space in the default or specified tablespace. If that fails to correct the problem, contact Oracle Support Services.

update : 23-08-2017
ORA-13231

ORA-13231 - failed to create index table [string] during R-tree creation
ORA-13231 - failed to create index table [string] during R-tree creation

  • ora-28557 : unknown string for database link to non-Oracle system
  • ora-07490 : scgrcl: cannot convert lock.
  • ora-04020 : deadlock detected while trying to lock object stringstringstringstringstring
  • ora-01891 : Datetime/Interval internal error
  • ora-12927 : RETENTION option already specified
  • ora-30369 : maximum number of columns is 32
  • ora-23405 : refresh group number string does not exist
  • ora-39710 : only connect AS SYSDBA is allowed when OPEN in UPGRADE mode
  • ora-28263 : Insufficient memory in global context pool
  • ora-12612 : TNS:connection is busy
  • ora-12637 : Packet receive failed
  • ora-40201 : invalid input parameter string
  • ora-24079 : invalid name string, names with AQ$_ prefix are not valid for string
  • ora-13519 : Database id (string) exists in the workload repository
  • ora-38477 : attribute set cannot be derived from an evolved type or a subtype.
  • ora-12052 : cannot fast refresh materialized view string.string
  • ora-26694 : error while enqueueing into queue string.string
  • ora-02336 : column attribute cannot be accessed
  • ora-19615 : some files not found in backup set
  • ora-25196 : keyword MOVE in ALTER TABLE MOVE must immediately follow
  • ora-01590 : number of segment free list (string) exceeds maximum of string
  • ora-12011 : execution of string jobs failed
  • ora-06301 : IPA: Cannot allocate driver context
  • ora-16584 : illegal operation on a standby site
  • ora-09958 : IMON: two processes with the same ORACLE pid are active
  • ora-24073 : cannot specify RETENTION_TIME on exception queue string.string
  • ora-13701 : Snapshot pair [string, string] seems to be specified in reverse order.
  • ora-38433 : index "string" could not be maintained due to "string"
  • ora-31435 : an error occurred during the purge operation
  • ora-31633 : unable to create master table "string.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.