ORA-14405: partitioned index contains partitions in a
different tablespace



ORA-14405: partitioned index contains partitions in a different tablespace..

Answer / guest

Cause: An attempt was made to drop a tablespace which
contains indexes whose partitions 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 partitions 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

RMAN-08582: channel string: starting archive copy

1 Answers  


NID-00500: Keyword Description (Default)

1 Answers  


PCB-00501: Runtime context variable "string" not of correct type

1 Answers  


ORA-13340: a point geometry has more than one coordinate

1 Answers  


ORA-38489: predicate table creation failed due to: ORAstring

1 Answers  






ORA-02782: Both read and write functions were not specified

1 Answers  


ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT <rbs>

1 Answers  


RMAN-06207: WARNING: string objects could not be deleted for string channel(s) due

1 Answers  


ORA-29532: Java call terminated by uncaught Java exception: string

1 Answers  


IMP-00014: option "string" is needed, but not present in database

1 Answers  


CLSR-01004: Failed to mount database

1 Answers  


ORA-31035: Could not bind locked resource to path string/string

1 Answers  


Categories