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 : 30-04-2017

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-30356 : the specified refresh method is not supported in this context
  • ora-00037 : cannot switch to a session belonging to a different server group
  • ora-32131 : bind data type cannot be changed
  • ora-22315 : type "string" does not contain a map or order function
  • ora-13147 : failed to generate MBR
  • ora-14639 : SUBPARTITIONS clause can be specfied only for Hash, Composite Range Hash table/partition
  • ora-30029 : no active undo tablespace assigned to instance
  • ora-28512 : cannot get data dictionary translations from string
  • ora-17613 : Failed to initialize Oracle Disk Manager library: string
  • ora-12733 : regular expression too long
  • ora-38757 : Database must be mounted and not open to FLASHBACK.
  • ora-29255 : Cursor contains both bind and define arrays which is not permissible
  • ora-19931 : file string has invalid creation SCN string
  • ora-07581 : spstp: cannot derive SID from unexpected process name
  • ora-15008 : cannot drop system template
  • ora-24082 : propagation may still be happening for the schedule for QUEUE string and DESTINATION string
  • ora-19000 : missing RELATIONAL keyword
  • ora-07243 : supplied buffer not big enough to hold entire line
  • ora-12424 : length exceeds binary label size
  • ora-27201 : skgfpcm: sbtpccommit returned error
  • ora-01982 : invalid auditing option for tables
  • ora-14186 : number of sub-partitions of LOCAL index must equal that of the underlying table
  • ora-00071 : process number must be between 1 and string
  • ora-02422 : missing or invalid schema element
  • ora-09313 : slsprom: error prompting user
  • ora-14323 : cannot add partition when DEFAULT partition exists
  • ora-31525 : could not find column string in CDC change table string.string
  • ora-00449 : background process 'string' unexpectedly terminated with error string
  • ora-13338 : failure in reversing LRS polygon/collection geometry
  • ora-09930 : LUB of two labels is invalid
  • 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.