Entry for Domain Index Not Getting Cleared From Dependency$ After Drop Index. (Doc ID 2593335.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Domain Index is not getting cleared from dependency$ after delete.

Number of rows in dependency$ remains the same after dropping the Spatial index.

However, it's increased by 1 when recreating the index:

CREATE INDEX <index_name> ON <table_name(<column_name>)   INDEXTYPE IS MDSYS.SPATIAL_INDEX;

Index created.

select count(*) from sys.dependency$;

      COUNT(*)
--------------
        221649

1 row selected.

drop index <index_name>;

Index dropped.

select count(*) from sys.dependency$;

      COUNT(*)
--------------
        221649

1 row selected.

CREATE INDEX <index_name> ON <table_name(<column_name>)    INDEXTYPE IS MDSYS.SPATIAL_INDEX;

Index created.

select count(*) from sys.dependency$;

      COUNT(*)
--------------
        221650

1 row selected.

drop index <index_name>;

Index dropped.

select count(*) from sys.dependency$;

      COUNT(*)
--------------
        221650

1 row selected.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.