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

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

  • ora-25403 : could not reconnect
  • ora-01681 : max # extents (string) reached in LOB segment in tablespace string
  • ora-13230 : failed to create temporary table [string] during R-tree creation
  • ora-34841 : (OPCREATE02) The string option must be declared with the READONLY attribute.
  • ora-07615 : $CHANGE_CLASS failed in retrieving the specified file label
  • ora-07548 : sftopn: Maximum number of files already open
  • ora-01470 : In-list iteration does not support mixed operators
  • ora-02726 : osnpop: access error on oracle executable
  • ora-10842 : Event for OCI Tracing and Statistics Info
  • ora-10906 : Unable to extend segment after insert direct load
  • ora-01207 : file is more recent than control file - old control file
  • ora-25312 : Cannot specify nonzero sender protocol
  • ora-06004 : NETASY: dialogue file open failure
  • ora-25507 : resource manager has not been continuously on
  • ora-00211 : control file does not match previous control files
  • ora-36685 : (XSDPART23) Only CONCAT partition templates can be subpartitioned.
  • ora-07455 : estimated execution time (string secs), exceeds limit (string secs)
  • ora-06737 : TLI Driver: connection failed
  • ora-01269 : Destination parameter string is too long
  • ora-02069 : global_names parameter must be set to TRUE for this operation
  • ora-07600 : slkmnm: $GETSYIW failure
  • ora-24011 : cannot drop QUEUE, string should be stopped first
  • ora-27026 : skgfrls: sbtend returned error
  • ora-07208 : sfwfb: failed to flush dirty buffers to disk.
  • ora-16065 : remote archival disabled at standby destination
  • ora-14067 : duplicate TABLESPACE_NUMBER specification
  • ora-34346 : (MXDSS04) The string analytic workspace cannot be detached.
  • ora-28550 : pass-through SQL: cursor not found
  • ora-09266 : spawn: error starting an Oracle process
  • ora-00202 : control file: '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.