My Oracle Support Banner

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

Last updated on APRIL 30, 2020

Applies to:

Oracle Text - Version 12.1.0.2 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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