×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!
  • Students Click Here

*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

Set of tables – Creation and updates

Set of tables – Creation and updates

Set of tables – Creation and updates

(OP)
Good Day,

I'm looking at six relatively small tables that I have no information about the way they are supposed to be updated. Can I find out when the rows got updated the last time?

Regards,
Dan

RE: Set of tables – Creation and updates

Dan,

The Oracle Data Dictionary automatically stores when a table was created or its structure last changed (DBA_OBJECTS.CREATED and LAST_DDL_TIME). In our application's tables, we have CREATED_DATE, CREATED_BY, UPDATED_DATE, and UPDATED_BY, which document WHO and WHEN the tables' rows were last changed and by whom.

If you thought ahead of time to turn on Oracle AUDITING, then entries would appear in SYS.AUD$. (As a DBA, you can DESCRIBE SYS.AUD$ and find out all about the AUD$ table with a Google of "Oracle AUDIT AUD$".

santaMufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel."

RE: Set of tables – Creation and updates

(OP)
Hi Mufasa,

I can't access for some reason the dba_objects view.

The following does work -

CODE

select * from all_objects where object_name like 'XMC%' and object_type = 'TABLE' 

Many thanks.

Regards,
Dan

RE: Set of tables – Creation and updates

That means that you are not a member of the "DBA" role. Regardless of user, you will always have access to the "USER_*" and "ALL_*" data dictionary views.

santaMufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel."

RE: Set of tables – Creation and updates

(OP)
Thank you Mufasa.

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