Frequently asked question

What are the SDE db_ev_* triggers used for with Oracle?

Last Published: April 25, 2020

Answer

The sde schema's db_ev_alter_st_metadata, db_ev_drop_st_metadata, and db_ev_rename_metadata triggers are database event triggers used to maintain the st_geometry metadata tables when tables containing st_geometry attributes are altered, dropped, or renamed.

The db_ev_alter_st_metadata trigger is executed after every ALTER TABLE command in the database. The trigger first checks if the table being altered is registered as an st_geometry table, and if it is, updates the metadata accordingly based upon the event.

The db_ev_drop_st_metadata trigger is executed after every DROP TABLE command in the database. The trigger checks if the table being dropped contains an st_geometry attribute; if yes, the trigger removes the metadata from the st_geometry_columns and st_geometry_index tables.

The db_ev_rename_st_metadata trigger is executed after every RENAME command in the database. The trigger checks if the table being renamed contains an st_geometry attribute; if yes, the trigger updates the metadata to reflect the new name of the table.

These triggers should never be modified or removed from the sde schema or the st_geometry metadata will not be correctly maintained as schema changes occur in the Oracle instance.

Article ID:000010082

Software:
  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options