473,320 Members | 1,948 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Regarding Object ID in oracle

Hi Mark,
I 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 the same name (trig1). I can see the object_id did not changed. Why? As we know object_id is primary key.

Please help me out of this.

Thanks in advance.
Prosenjit.
Jul 4 '11 #1

✓ answered by rski

Assigning object_id is hidden from user but I think it should be done with some defined sequence.
I tried to repeat what you did but with no success (reacreated trigger has another object_id). Which oracle version do you use?

1 2678
rski
700 Expert 512MB
Assigning object_id is hidden from user but I think it should be done with some defined sequence.
I tried to repeat what you did but with no success (reacreated trigger has another object_id). Which oracle version do you use?
Jul 5 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Prabhakar Chola | last post by:
I got this error on production and I rebooted the server and the problem went away. It happens at random. Please help. Environment W2K with Oracle 9.2 client connected to oracle using...
0
by: Max | last post by:
Hi wise people, Has anyone encountered the Crystal Reports problem I describe below? If so, how did you solve it? It seems that every article posted on google regarding CR and logon problems is...
7
by: dm_dal | last post by:
Just a quick question regarding object scope and lifetime. Given the following: { DataRow myRow = new DataRow(); ...... do some stuff { myRow = new DataRow; ..... do some stuff
2
by: Steve Foo | last post by:
I have been posting this question in google group, EE, and Oracle OTN forum and still no cannot find a suitable solution for it. I have contacted Singapore Microsoft support regarding the problem...
4
by: BookerW | last post by:
I am not sure which forum I should post this on, but here is the problem. I have a front end web application(VB) on asp,net 1.1 framework. Inside of the code, I have the following lines to...
56
by: Ashish Patankar | last post by:
I want to migrate my Oracle 10g database to Db2. I want some documentation for the comparision between these to databases. I also want to know which features of Oracle 10g are supported by Db2 and...
22
by: Michael Pradel | last post by:
Hi all, I just returned to C++ after programming in other languages, and find myself a bit puzzled about the following issue: (see attached code). How can I avoid the deletion of an object...
16
by: network-admin | last post by:
We have Problems with Access query on Oracle 10g Database with ODBC Connection. The Query_1 is such as select * from xtable where ycolumn <"S" Result = ODBC Faild...
3
by: amitabhcy | last post by:
Hello to members, I am getting fatal error while running the following code. Any solutions to avoid the error. The error is PHP Fatal error: Call to a member function getD() on a non-object in...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.