When I drop a table space as so “drop tablespace MMAX_MFINC_2018;”, I get an error stating that it is not empty so I did this “drop tablespace MMAX_MFINC_2018 including contents and datafiles;” I then get this error ORA-14404: partitioned table contains partitions in a different tablespace. We deleted all partitions for that year.
So I did this to look at the segments
select * from dba_segments where tablespace_name = 'MMAX_MFINC_2018' order by 1,2,3;
MAXDATA MROLL_3YR_SLS MROLL_3YR_SLS_47_201801 TABLE PARTITION ASSM MMAX_MFINC_2018 68 5600642 260046848 31744 102 65536 1048576 1 2147483645 2147483645
How do you delete table spaces? There are 142 rolls but they point to the same tablespace. Shouldn't the including contents and datafiles got removed?