TRIGGER: MDSYS.SDO_INDEX_METADATA_UPDATE

Source

Description

SDO_INDEX_METADATA_UPDATE
AFTER UPDATE OR DELETE ON MDSYS.SDO_INDEX_METADATA_TABLE
FOR EACH ROW

Type

AFTER EACH ROW

Event

UPDATE OR DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN


  mdsys.mdprvt_idx.invalidate_cache(:old.sdo_index_owner,
                                    :old.sdo_index_name,
                                    :old.sdo_index_partition,
                                    :old.sdo_index_table);
END;