Showing posts with label ORA-14404: partitioned table contains partitions in a different tablespace. Show all posts
Showing posts with label ORA-14404: partitioned table contains partitions in a different tablespace. Show all posts

Saturday, 17 March 2012

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

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

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