Results 1 to 9 of 9

Thread: DB Objects List

  1. #1
    Join Date
    Jul 2003
    Location
    Pune, India
    Posts
    5

    DB Objects List

    Hi All,

    I was wondering if we have any way of getting a list of objects (Tables ofcourse) that got affected in the past 'n' minutes. I am aware of the Audit Trail facility, which has to be manually set; I was looking at something at core DB level functions that keep track of the changes to the Tables.

    Regards,
    Engi....

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Look at LAST_DDL_TIME column in DBA_OBJECTS table.

  3. #3
    Join Date
    Jul 2003
    Location
    Pune, India
    Posts
    5
    Hi shailesh,

    I think i need to rephrase my query; thoroughly confused everyone. What I am looking for is the object list which were affected due one of the DML Operations. What Last_ddl_time gives is the date on which the structure was altered someway or the other [if i am not wrong]. I need something like Last_DML_Time.

    Hope now I am clear with my requirement. Anyways thank you for the earlier reply.

    Regards
    Engi

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    I don't think you can do that without using Audit Trail (either Oracle provided or your own)

  5. #5
    Join Date
    Jul 2003
    Location
    Pune, India
    Posts
    5

    Unhappy

    Thanks Shailesh..... and I am doomed....

    Guess have to manually see every table to see if there was any change...

    :-(

    Regards
    Engi

  6. #6
    Join Date
    Jun 2003
    Posts
    16

    How about a trigger?

    On insert, delete or update.

    Indeed this is a personal way of tracking the changes, but it might lead u somewhere.
    With the right packages and mail configuration on the server u might even get to e-mail u the changes on a daily basses.

    good luck

  7. #7
    Join Date
    Mar 2003
    Posts
    468
    if you are using 9.2.0 you could look into configuring STREAMS for getting this information.

  8. #8
    Join Date
    Sep 2003
    Posts
    2

    Thumbs up

    Hi

  9. #9
    Join Date
    Sep 2003
    Posts
    2
    Hi
    Alter table <table name> monitoring;

    the view user_tab_modifications lists out number of updates ,inserts and deletes performed.
    The TIMESTAMP column indicates the last time the data has been changed.
    But the view is affected only after certain time of DML action due to performance reasons.

    Hope this helps you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •