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

O2F-00306: Unable to close the INTYPE file

1 Answers  


ORA-25441: duplicate column value for table alias: string

1 Answers  


RMAN-10038: database session for channel string terminated unexpectedly

1 Answers  


ORA-09369: Windows 3.1 Two-Task driver bad instance handle

1 Answers  


ORA-01079: ORACLE database was not properly created, operation aborted

1 Answers  






RMAN-05018: some datafile copies cannot be recovered, aborting the RECOVER command

1 Answers  


PCC-02392: You are already in an EXEC SQL DECLARE SECTION

1 Answers  


EXP-00061: unable to find the outer table name of a nested table

1 Answers  


AMD-00136: Generation of SQL script "string" failed

1 Answers  


ORA-25254: time-out in LISTEN while waiting for a message

1 Answers  


ORA-02181: invalid option to ROLLBACK WORK

1 Answers  


DRG-11621: URL store: socket open error for string

1 Answers  


Categories