Knowledge Base - Technical Articles


Technical Article   FAQ:  What are the SDE db_ev_* triggers used for with Oracle?

Article ID: 34982
Software:  ArcSDE 9.3, 9.3.1
Platforms: N/A

Question

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

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.

Created: 6/9/2008
Last Modified: 5/3/2011

Article Rating: (2)
If you would like to post a comment, please login

Comments

By bmanasadevi - 08/22/2014 4:24 AM

I would like to see a new article that discusses the topic outlined below.

OK.. I could not validate those triggers but after a lot of brainstorming on this issue.. I disabled those triggers and was able to delete that particular entire oracle schema and loaded data into afresh schema again. That was the work around I did on my own. And would suggest ESRI to have a faster and better tech support to address user's issue.

Rating:

By bmanasadevi - 08/19/2014 11:35 PM

I would like to see a new article that discusses the topic outlined below.

Hi I am facing error ORA-04045 saying-schemaname.db_ev_drop_st_metadat errors during recompliation/revalidation followed by another error ORA-04098 saying- schemaname.db_ev_alter_st_metadata is invalid & failed revalidation even if i am trying to change password or delete the user/schema. what is the work around for this error??

Rating: