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-13635: The value string provided for parameter string cannot be converted to a number.

1 Answers  


SQL-02124: NULL value returned by EXEC TOOLS statement

1 Answers  


TNS-04210: Trace Assistant Internal ERROR: End of File

1 Answers  


ORA-06904: CMX: no transport address available for remote application

1 Answers  


ORA-00450: background process 'string' did not start

1 Answers  






SQL*Loader-00415: column string in table string cannot use and be the object of an SDF or LOBFILE

1 Answers  


ORA-22914: DROP of nested tables not supported

1 Answers  


PLS-00354: username must be a simple identifier

1 Answers  


ORA-02072: distributed database network protocol mismatch

1 Answers  


ORA-32106: array fetch not allowed without setBuffer on all columns

1 Answers   Oracle,


ORA-25205: the QUEUE string.string does not exist

1 Answers  


ORA-02329: column of datatype string cannot be unique or a primary key

1 Answers  


Categories