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



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

Answer / guest

Cause: An attempt was made to drop a tablespace which
contains tables whose subpartitions are not completely
contained in this tablespace

Action: find tables with subpartitions which span the
tablespace being dropped and some other tablespace(s). Drop
these tables or move subpartitions to a different tablespace

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22953: Cardinality of the input to powermultiset exceeds maximum allowed

1 Answers  


ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

1 Answers  


KUP-04074: no write access to directory object string

2 Answers  


ORA-16567: Data Guard broker internal parser error at "string"

1 Answers  


ORA-33219: (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.

1 Answers  






RMAN-06527: KEEP option is not supported for backup of backup sets

1 Answers  


ORA-03213: Invalid Lob Segment Name for DBMS_SPACE package

1 Answers  


ORA-24369: required callbacks not registered for one or more bind handles

1 Answers  


PLS-00148: Only 1 pragma of this type is allowed per subprogram

1 Answers  


SQL*Loader-00524: partial record found at end of datafile (string)

1 Answers  


ORA-16586: Could not edit database property through instance.

1 Answers  


TNS-01027: Listener Trace File string

1 Answers  


Categories