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-32031: illegal reference of a query name in WITH clause

2 Answers  


ORA-19631: archivelog record contains no file name

1 Answers  


ORA-12434: invalid audit type: string

1 Answers  


TNS-12218: TNS:unacceptable network configuration data

1 Answers  


ORA-09241: smsalo: error allocating SGA memory

1 Answers  






RMAN-08085: created script string

1 Answers  


ORA-22862: specified object identifier doesn't match existing object identifier

1 Answers  


ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped

1 Answers  


ORA-06262: NETNTT: nfconn() failed

1 Answers  


ORA-06579: Bind variable not big enough to hold the output value

1 Answers  


ORA-12225: TNS:destination host unreachable

1 Answers  


DRG-11600: URL store: string has permanently moved

1 Answers  


Categories