DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002

    Strange Problem !!

    Hello all..

    We have a 3rd party tool that we use to keep track of the time each person worked on each project...This application is Connected to Oracle 9.2 thru ODBC connection

    Now In this Application, we have GUI screens and one of the screens 'Customer screen' lets us to create/modify USER id and password. Once we modify the data, it tells you what time the data is modified at the bottom of the screen.

    Now I need to find out which table in DB is getting updated when i make a change to 'customer Screen'.

    This application uses about 70 tables....
    So my question is Is there a Way to find out which table is this Customer Info stored like Id's and Passsword. I have seen a table that has the ID's. But no password Field....


  2. #2
    Join Date
    Jul 2002
    There are several options

    1. In your test system:

    Turn on auditing in the DB (Audit ALL)

    Log on to your application and perform your 'Customer screen' create/update/delete.

    Check the Oracle audit table (SYS.AUD$)


    2. Use logminer...

    Fast, Cheap, Reliable... Pick Two(2)

  3. #3
    Join Date
    Aug 2002
    Colorado Springs
    Turn on SQL logging in ODBC would be a quick way
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.