Bizarre tables: starting with MD* . Let's drop some.
What are these strange tables starting with MD*? Can I drop them? I will answer first: Yes, You can drop some of them if your Oracle DB version is 12cR2 or later. But which ones? There were over 3000 tables starting with 'MD*' letters in one of our production database. I knew that those tables are related with Spatial indexes. But that was a huge amount. So I took a deep dive into the spatial indexes. For each spatial index created, one table named like "MDRT_#" is created also. There is a one to one relationship (except the partitioned ones) between them. There are also tables named like "MDXT_#, MDXT_#_BKTS, MDXT_#_MBR". According to the Doc Id 1916251.1 , these tables are created for supporting statistics on Spatial Index and after the statistic analyzing is finished, MDXT_#_BKTS and MDXT_#_MBR should be dropped automatically. But somehow, we had lots of them. Also Doc Id 2029072.1 states that "Dropping these temporary tables ( MDX