Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Oracle 7 unique TABLE_ID's

Oracle 7 unique TABLE_ID's

Oracle 7 unique TABLE_ID's

I have a small table in which we store a unique TABLE_ID. Don't ask why!! It was set up by Oracle for us.
Now, we have added some new tables and I need to populate this Table data into the unique TABLE_ID's.
Can anybody tell me where the unique table_id id stored in the database?
I have talked to the DBA that we use, and he is not certain either.

MADRE Data Warehouse Admin.

RE: Oracle 7 unique TABLE_ID's

Is this not a Sequence?  If it's not, and you're getting all of your unique ID's from a user table, then that table should be visible to at least the developer, and if not, the dba should be able see it.  If you only need unique ID's on a per table basis, a sequence is the way to go.  If, for some reason, you need unique id's across all tables, then you've got to find that table, and if the dba can't, something isn't right.

RE: Oracle 7 unique TABLE_ID's

Yes, the question is a little unclear.  You can always create a sequence for your table that will provide a unique id.

If you need the id from the Oracle catalog, I think you can get it from the view ALL_OBJECTS.  You would populate your TABLE_ID column with ALL_OBJECTS.OBJECT_ID
 where object_type='TABLE'
 and owner='new_table_owner'
 and object_name='new_table_name'.

Good luck.  I hope this helps.

RE: Oracle 7 unique TABLE_ID's

TABLE_ID? What's the table name? And are you *sure* you need this? It doesn't sound as if it's a standard Oracle table, is it required by one of your applications?


Cargill's Corporate Web Site
Please don't send me email questions without posting them as well. Post the question and send me a note saying "Have a look at so-and-so would you?" - that's fine.

RE: Oracle 7 unique TABLE_ID's

I would recommend checking your DBA_DEPENDENCIES view to see if anything actually depends on this table.  If not, I wouldn't worry about it.
If it turns out you DO need it, I would get hold of the consultant who set it up and make him/her explain how the mechanism works.
This is NOT a standard Oracle table.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close