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-13603: The specified parameter string cannot be fetched as a numeric value for task or object string.

1 Answers  


ORA-13375: the layer is of type [string] while geometry inserted has type [string]

1 Answers  


ORA-38952: Source database not 10.0.0.0 compatible

1 Answers  


QSM-00769: the SQL statement string was not found for workload string

1 Answers  


SQL*Loader-00628: Character set conversion error.

1 Answers  






PCC-00069: Host variable "string" has unsupported datatype at line number in file string

1 Answers  


LSX-00018: invalid schema context

1 Answers  


ORA-28669: bitmap index can not be created on an IOT with no mapping table

1 Answers  


QSM-01102: materialized view, string, requires join back to table, string, on column, string

1 Answers  


ORA-15150: instance lock mode 'string' conflicts with other ASM instance(s)

1 Answers  


NNL-00209: Cache checkpoint interval is currently string

1 Answers  


PLS-00642: local collection types not allowed in SQL statements

1 Answers  


Categories