This discussion is archived
1 Reply Latest reply: Oct 17, 2012 7:28 AM by Ben Speckhard RSS

Get Triggers from Version Enabled Table in Oracle

rcx4009v2 Newbie
Currently Being Moderated
I am new to Oracle Workspace Manager. I have a trigger that fills my IDs everytime i insert a record. I created the trigger before I enable the versioning of my table. After versioning was enabled in my table, I can no longer find my trigger but have these triggers instead:

OVM_DELETE_7 OVM_INSERT_7 OVM_UPDATE_7

What I wanted to do is Query the triggers that I created on my tables. Is there a way to do that without disabling the versioning on my table? I have too many versioned-enabled tables and that would be a hassle disabling the version in every table just for that query.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points