Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

NNL-00035: File string or nested IFILEs not found.

1 Answers  


ORA-01117: adding file 'string' with illegal block size: string; limit is string

1 Answers  


SQL*Loader-00422: constant element count of number for column string is greater than maximum, number

1 Answers  


ORA-12033: cannot use filter columns from materialized view log on "string"."string"

1 Answers  


ORA-01216: thread string is expected to be disabled after CREATE CONTROLFILE

1 Answers  






ORA-39706: schema 'string' not found

1 Answers  


ORA-32633: MODEL subquery FOR cell index returns too many rows

1 Answers  


PCC-02327: struct or struct pointer required

1 Answers  


ORA-24156: duplicate table alias string

1 Answers  


ORA-22912: specified column or attribute is not a nested table type

1 Answers  


LPX-00101: parameter-entity markup cannot be split up

1 Answers  


ORA-19598: can not backup SPFILE because the instance was not started with SPFILE

1 Answers  






Categories