I was cleaning up tablespaces and wanted to delete one, and after moving all the segments from it, I got the following:
SCOTT.OE> drop tablespace fact_index including contents and datafiles;
drop tablespace fact_index including contents and datafiles
*
ERROR at line 1:
ORA-14405: partitioned index contains partitions in a different tablespace
I tried looking for where all the schemas had data in all tablespaces. No luck.
Asked by Mark Stewart
(1168 rep)
Mar 1, 2024, 07:27 PM
Last activity: Mar 1, 2024, 08:32 PM
Last activity: Mar 1, 2024, 08:32 PM