Avoidance of ORA-14511 in partitioned tables
We have a partitioned table EXF.PART_TABLE
We can move the partiones by
ALTER TABLE EXF.PART_TABLE MOVE PARTITION PART01 TABLESPACE TS_EXF_PART;
This leaves part_table itself still in TS_EXF
When we try this
ALTER TABLE EXF.PART_TABLE MOVE TABLESPACE TS_EXF_PART;
we get
ORA-14511: cannot perform operation on a partitioned object
which I would assume means we better not eliminate TS_EXF
My question is, ¿how do we disassociate the table exf.part_table from the tablespace TS_EXF in order that we can delete the Tablespace in question?