ORA-14458: attempt was made to create a temporary table with INDEX organization

Cause : An attempt was made to create an Index Organized Temporary table. This is not supported.

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

Create the table with HEAP organization and the primary key.

update : 25-04-2017
ORA-14458

ORA-14458 - attempt was made to create a temporary table with INDEX organization
ORA-14458 - attempt was made to create a temporary table with INDEX organization

  • ora-31052 : Cannot delete ACL with other references
  • ora-13482 : GeoRaster object is not initialized for the image
  • ora-06924 : CMX: wrong break message length
  • ora-16748 : resource guard encountered errors during database open
  • ora-30935 : XML maxoccurs value (string) exceeded
  • ora-03113 : end-of-file on communication channel
  • ora-30567 : name already used by an existing log group
  • ora-19672 : media management software returned invalid file status
  • ora-23462 : flavor string in use at site string
  • ora-39000 : bad dump file specification
  • ora-31220 : DBMS_LDAP: PL/SQL - Invalid LDAP SSL wallet location.
  • ora-29364 : plan directive string, string already exists
  • ora-01226 : file header of log member is inconsistent with other members
  • ora-13411 : subset results in null data set
  • ora-29321 : too many datafiles added since the point-in-time
  • ora-29884 : domain index is defined on the column to be dropped
  • ora-13901 : Object string was not found.
  • ora-27366 : job "string.string" is not running
  • ora-13790 : invalid value for time limit
  • ora-14050 : invalid ALTER INDEX MODIFY PARTITION option
  • ora-25446 : duplicate column value for table alias: string, column: string
  • ora-26500 : error on caching "string"."string"
  • ora-01139 : RESETLOGS option only valid after an incomplete database recovery
  • ora-02213 : duplicate PCTUSED option specification
  • ora-07589 : spdde: system ID not set
  • ora-25532 : MTTR specified is too large: string
  • ora-14158 : too many subpartition descriptions
  • ora-00265 : instance recovery required, cannot set ARCHIVELOG mode
  • ora-07757 : slemcc: invalid handle
  • ora-22864 : cannot ALTER or DROP LOB indexes
  • 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.