ORA-14408: partitioned index contains subpartitions in a different tablespace

Cause : Ana ttmeptw asm ad etod ro pa atblsepaec wihchc onatin sinedxe swhsoe usbpratiiton sar eno tcopmleetlyc onatinde i nthsi tbalepsac,e adn wihcha red efniedo n hte atblse wihcha rec omlpetley ocntiane dint hi stalbesapce.

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

fidn idnexse wtih usbpratiiton swhcih psant het abelspcae ebin gdrpope dan dsoem ohtert abelspcae()s. rDopt hees idnexse, ro mvoe hte nide xpatritoinst o adiffernet atblsepaec, ro fnid hte atblse o nwhcih hte nideexs rae edfiend,a ndd ro p(o rmoev) htem.

update : 20-07-2017
ORA-14408

ORA-14408 - partitioned index contains subpartitions in a different tablespace
ORA-14408 - partitioned index contains subpartitions in a different tablespace

  • ora-29367 : object string does not exist
  • ora-27374 : insufficient privileges on event source queue
  • ora-37127 : (XSCCOMP02) The COMPRESSED COMPOSITE workspace object must be last in the dimension list.
  • ora-33302 : (DBVALID01) SEVERE ERROR: Record number multiply used.
  • ora-39766 : invaid stream specified for column array conversion
  • ora-39068 : invalid master table data in row with PROCESS_ORDER=string
  • ora-22897 : no scope clause specified for user-defined REF column "string"
  • ora-24508 : Buffer is not aligned correctly.
  • ora-19124 : fn:one-or-more() called with a sequence containing no items
  • ora-03236 : max # extents (string) reached in index string.string subpartition string
  • ora-12662 : proxy ticket retrieval failed
  • ora-28520 : error initializing heterogeneous data dictionary translations
  • ora-13430 : the GeoRaster object has null attribute(s)
  • ora-36848 : (XSLMGEN18) Dimension string.string!string is missing a COLUMNNAME property value
  • ora-31232 : DBMS_LDAP: invalid MOD_PROPERTY_SET
  • ora-16583 : bad Data Guard Connection Process DRCX state
  • ora-31420 : unable to submit the purge job
  • ora-19694 : some changed blocks were not found in the change tracking file
  • ora-10640 : Operation not permitted during SYSTEM tablespace migration
  • ora-02462 : Duplicate INDEX option specified
  • ora-19612 : datafile string not restored due to string
  • ora-00376 : file string cannot be read at this time
  • ora-25328 : %s argument size string is smaller than array size
  • ora-25444 : invalid ROWID: string for table alias: string
  • ora-09350 : Windows 32-bit Two-Task driver unable to allocate context area
  • ora-13036 : Operation [string] not supported for Point Data
  • ora-22866 : default character set is of varying width
  • ora-24150 : evaluation context string.string does not exist
  • ora-22816 : unsupported feature with RETURNING clause
  • ora-38907 : DML error logging is not supported for FILE column "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.