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 : 27-05-2017
ORA-14408

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

  • ora-13189 : recursive SQL parse failed
  • ora-32311 : materialized view definition query selects an unsupported user-defined type
  • ora-16003 : standby database is restricted to read-only access
  • ora-24030 : Only one of rule or rule-set must be specified
  • ora-39018 : master process received invalid message number string
  • ora-09958 : IMON: two processes with the same ORACLE pid are active
  • ora-39766 : invaid stream specified for column array conversion
  • ora-12671 : Shared server: adapter failed to save context
  • ora-28553 : pass-through SQL: invalid bind-variable position
  • ora-01550 : cannot drop system tablespace
  • ora-14081 : new partition name must differ from the old partition name
  • ora-22297 : warning: Open LOBs exist at transaction commit time
  • ora-36814 : (XSTBLFUNC07) The datatype of the column used in the ROW2CELL clause of a LIMITMAP must be RAW(16).
  • ora-32831 : timed out trying to acquire administration lock
  • ora-36833 : (XSLMGEN03) View token cannot be blank
  • ora-13766 : A ranking measure is required.
  • ora-12052 : cannot fast refresh materialized view string.string
  • ora-40101 : Data Mining System Error string-string-string
  • ora-39041 : Filter "string" either identifies all object types or no object types.
  • ora-32101 : cannot create OCI Environment
  • ora-15036 : disk 'string' is truncated
  • ora-02243 : invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
  • ora-19757 : could not resize change tracking file to string blocks
  • ora-39202 : Data cannot be filtered or selected in string jobs.
  • ora-34344 : (MXDSS03) Analytic workspace string is not attached.
  • ora-38769 : FLASHBACK DATABASE failed after modifying data.
  • ora-03132 : two-task default value overflow
  • ora-12515 : TNS:listener could not find a handler for this presentation
  • ora-39175 : Encryption password is not needed.
  • ora-13369 : invalid value for etype in the 4-digit format
  • 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.