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

ORA-04068: existing state of packagesstringstringstring has been discarded

1 Answers  


ORA-12402: invalid format string: string

1 Answers  


ORA-09916: Required password was not specified.

1 Answers  


ORA-28003: password verification for the specified password failed

1 Answers  


ORA-19560: %s is not a valid device limit

1 Answers  






RMAN-06485: changed archivelog expired

1 Answers  


SQL-01075: you are currently logged on

1 Answers  


NNL-00211: Cache checkpoint interval is now string

1 Answers  


IMP-00041: Warning: object created with compilation warnings

1 Answers  


NNL-00009: encryption of server password failed

1 Answers  


PLS-00661: RETURN statement in a CONSTRUCTOR cannot include an expression

1 Answers  


SQL*Loader-00620: Initial enclosure character not found

1 Answers  


Categories