Databases@Powered by Passion

Month: March 2022

  • Dropping unused MDRT tables in Oracle database

    Dropping unused MDRT tables in Oracle database

    —

    by

    Osman DİNÇ
    , ,

    The MDRT_$ tables in Oracle Spatial are crucial for spatial indexes and should not be moved, altered, or replicated. It’s possible to drop unrelated tables if using Oracle DB version 12cR2 or later. While MDXT_# tables, which supported spatial index statistics, can be dropped after use, changes to the tablespace for MDRT_# tables are permitted. Queries are provided to identify and clean up unnecessary tables, resulting in a significant reduction in table count.