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-23533: object "string"."string" can not be cached

1 Answers  


QSM-01572: equivalence, string, and query have different joins between tables, string

1 Answers  


LPX-00664: VM Node-Stack overflow.

1 Answers  


TNS-01073: Listening on: string

1 Answers  


PLS-00215: String length constraints must be in range (1 .. 32767)

2 Answers  






ORA-12043: invalid CREATE MATERIALIZED VIEW option

1 Answers  


PCC-02335: body of cursor must name statement identifier

1 Answers  


PLS-00992: Cursor Variables cannot be FETCH'ed from

1 Answers   Wipro,


NNL-00283: Next cache checkpoint occurs in string

1 Answers  


ORA-02142: missing or invalid ALTER TABLESPACE option

1 Answers  


ORA-14309: Total count of list values exceeds maximum allowed

1 Answers  


ORA-31160: max substitution group size string exceeded by "string" (string) for head element "string" (string)

1 Answers  


Categories