ORA-14404: partitioned table contains partitions in a
different tablespace



ORA-14404: partitioned table contains partitions in a different tablespace..

Answer / guest

Cause: An attempt was made to drop a tablespace which
contains tables whose partitions are not completely
contained in this tablespace

Action: find tables with partitions which span the
tablespace being dropped and some other tablespace(s). Drop
these tables or move partitions to a different tablespace

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30680: debugger connection handshake failed

1 Answers  


TNS-04202: Trace Assistant Usage ERROR: Not enough arguments

1 Answers  


NNL-00910: VERSION SKEW responses sent: number

1 Answers  


ORA-39028: cannot restart job from string state

1 Answers  


ORA-06020: NETASY: initialisation failure

1 Answers  






QSM-00754: task string does not reference a valid workload and therefore cannot be executed

1 Answers  


IMG-00001: unable to initialize Oracle interMedia environment

1 Answers  


ORA-40219: apply result table string is incompatible with current operation

1 Answers  


ORA-27481: "string.string" has an invalid schedule

1 Answers  


ORA-25000: invalid use of bind variable in trigger WHEN clause

1 Answers  


ORA-08185: Flashback not supported for user SYS

1 Answers  


PCC-02371: Illegal FOR clause

1 Answers  


Categories