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



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

Answer / guest

Cause: An attempt was made to drop a tablespace which
contains indexes whose subpartitions are not completely
contained in this tablespace, and which are defined on the
tables which are completely contained in this tablespace.

Action: find indexes with subpartitions which span the
tablespace being dropped and some other tablespace(s). Drop
these indexes, or move the index partitions to a different
tablespace, or find the tables on which the indexes are
defined, and drop (or move) them.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-28552: pass-through SQL: call flow error

1 Answers  


PLS-00561: character set mismatch on value for parameter 'string'

1 Answers  


ORA-06024: NETASY: VTM error

1 Answers  


ORA-14509: specified VALIDATE INTO table form incorrect

1 Answers  


ORA-32401: materialized view log on "string"."string" does not have new values

1 Answers  






PLS-00990: Index Tables of Cursor Variables are disallowed

1 Answers  


ORA-24281: invalid access past the maximum size of LOB parameter string

1 Answers  


TNS-00316: Ran out of data buffers in the pump

1 Answers  


ORA-00075: process "string" not found in this instance

1 Answers  


ORA-12532: TNS:invalid argument

1 Answers  


ORA-12229: TNS:Interchange has no more free connections

1 Answers  


ORA-32585: duplicate specification of a supplemental log attribute

1 Answers  


Categories