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 : 20-08-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-02047 : cannot join the distributed transaction in progress
  • ora-00828 : specified value of shared_pool_reserved_size inconsistent with internal settings
  • ora-23608 : invalid resolution column "string"
  • ora-22859 : invalid modification of columns
  • ora-13916 : Invalid value "string" specified for parameter "string"
  • ora-24163 : dblink is not supported in rules engine DDLs
  • ora-00366 : log string of thread string, checksum error in the file header
  • ora-08103 : object no longer exists
  • ora-24051 : cannot propagate object type payloads that have a REF attribute
  • ora-19915 : unable to encrypt pre-10.2 files
  • ora-16053 : DB_UNIQUE_NAME string is not in the Data Guard Configuration
  • ora-02162 : invalid value for MAXDATAFILES
  • ora-31485 : invalid database link
  • ora-13295 : geometry objects are in different coordinate systems
  • ora-01716 : NOSORT may not be used with a cluster index
  • ora-27204 : skgfpqr: sbtpcqueryrestore returned error
  • ora-23344 : constraint (string.string) does not exist
  • ora-12218 : TNS:unacceptable network configuration data
  • ora-23459 : flavor string must contain "string"
  • ora-00000 : normal, successful completion
  • ora-21500 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-26571 : %s.string.string: number of arguments (string) does not match replication catalog
  • ora-12409 : policy startup failure for string policy
  • ora-16178 : Cannot specify remote destinations in archivelog manual mode
  • ora-16786 : resource guard cannot access Data Guard broker metadata
  • ora-40303 : invalid prior probability specification
  • ora-01903 : EVENTS keyword expected
  • ora-01409 : NOSORT option may not be used; rows are not in ascending order
  • ora-14011 : names assigned to resulting partitions must be distinct
  • ora-38420 : invalid stored attribute sub-expression: 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.