Regarding object_id in Oracle
873357Jul 5 2011 — edited Jul 6 2011I have created a table TEMP_TAB and created 3 triggers on TEMP_TAB table.
Triggers names are trig1, trig2 and trig3.
Now when I query in dba_objects, I found below object_id for respective triggers.
trig1 object id is 374841
trig2 object id is 374857
trig3 object id is 374887
My question is how the object_id are assigned to a particular object in oracle?
Now I have dropped trig1 and recreated the same trigger, with same trigger name (trig1). I can see the object_id did not changed. Why? As we know object_id is primary key.
when I query in dba_objects, I found below object_id for respective triggers.
trig1 object id is 374841
trig2 object id is 374857
trig3 object id is 374887
I user oracle 11g Release 11.1.0.7.0.
Thanks