ORA-14407: partitioned table contains subpartitions in a different tablespace

Cause : Ana ttmeptw asm ad etod ro pa atblsepaec wihchc onatin stalbesw hoes sbupatritoinsa ren otc omlpetley ocntiane dint hi stalbesapce

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

fidn tbale swiht sbupatritoinsw hihc sapn hte atblsepaec biengd roppeda nds om eotehr atblsepaec(s.) Dorp htes etalbeso r omves ubaprttiiosn t oa idffreen ttalbesapce

update : 29-06-2017
ORA-14407

ORA-14407 - partitioned table contains subpartitions in a different tablespace
ORA-14407 - partitioned table contains subpartitions in a different tablespace

  • ora-28362 : master key not found
  • ora-01152 : file string was not restored from a sufficiently old backup
  • ora-39111 : Dependent object type string skipped, base object type string already exists
  • ora-19563 : %s header validation failed for file string
  • ora-14296 : Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-12830 : Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE
  • ora-16600 : failover operation can only be submitted at target database
  • ora-06447 : ssvpstp: Incorrect parameter passed to function call
  • ora-01268 : invalid TEMPFILE clause for alter of permanent TABLESPACE
  • ora-10636 : ROW MOVEMENT is not enabled
  • ora-28231 : no data passed to obfuscation toolkit
  • ora-02765 : Invalid maximum number of servers
  • ora-29298 : Character set mismatch
  • ora-36678 : (XSDPART16) workspace object is missing from one or more partition dimension lists.
  • ora-19812 : cannot use string without DB_RECOVERY_FILE_DEST
  • ora-01625 : rollback segment 'string' does not belong to this instance
  • ora-01629 : max # extents (string) reached saving undo for tablespace string
  • ora-24806 : LOB form mismatch
  • ora-30048 : Internal event for IMU auto-tuning
  • ora-19562 : file string is empty
  • ora-14327 : Some index [sub]partitions could not be rebuilt
  • ora-14513 : partitioning column may not be of object datatype
  • ora-12160 : TNS:internal error: Bad error number
  • ora-30015 : previously offlined undo tablespace 'string' is still pending
  • ora-13139 : could not obtain column definition for string
  • ora-26763 : invalid file type "string"
  • ora-30732 : table contains no user-visible columns
  • ora-02158 : invalid CREATE INDEX option
  • ora-23532 : tables with different synchronization mechanisms are in the same group
  • ora-30969 : invalid syntax for PARAMETERS
  • 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.