Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

DRG-13001: sub lexer and multi lexer must have the same owner

1 Answers  


NZE-28872: Invalid peer certificate format

1 Answers  


RMAN-05514: tablespace string has undo information, cannnot skip

1 Answers  


ORA-02736: osnfpm: illegal default shared memory address

1 Answers  


ORA-30001: trim set should have only one character

1 Answers  






ORA-28169: unsupported certificate type

1 Answers  


ORA-15052: ASM file name 'string' is not in diskgroup "string"

1 Answers  


ORA-26031: index maintenance error, the load cannot continue

1 Answers  


ORA-09983: skxfidsht: Error shutting down SDI channel

1 Answers  


PLS-01458: The set clause in an UPDATE statement requires a column name of length 1

1 Answers  


ORA-01626: rollback segment number 'string' cannot handle more transactions

1 Answers  


PLS-00612: Number of attributes do not match in SET clause

1 Answers  






Categories