1 Reply Latest reply: Oct 17, 2012 9:28 AM by Ben Speckhard-Oracle RSS

    Get Triggers from Version Enabled Table in Oracle

    rcx4009v2
      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.