Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2009
    Posts
    55

    Unanswered: how to know whoich table is update/modify in oracle

    Hi,
    I use oracle 9i.
    After doing execution ,process, how can I know which table in the oracle have been update/modify ??
    Please advice how to check it out ???


    Thank

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >After doing execution ,process, how can I know which table in the oracle have been update/modify ??
    >Please advice how to check it out ???

    DBMS_LOGMNR
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2009
    Posts
    55
    any other way apart from DBMS_LOGMGR ????

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by chuikingman View Post
    any other way apart from DBMS_LOGMGR ????
    AUDIT; but usually not enabled or not enabled for desired objects.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Database Monitoring Info

    Quote Originally Posted by chuikingman View Post
    any other way apart from DBMS_LOGMGR ????
    Well, you could set the tables to "monitoring" option and from now on just check the timestamp on {ALL|DBA|USER}_TAB_MODIFICATIONS.

    For performance reasons, the Oracle Database does not populate these views immediately when the actual modifications occur. You will need to run the FLUSH_DATABASE_MONITORING_INFO procedure in the DBMS_STATS PL/SQL package to populate these views with the latest information.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  6. #6
    Join Date
    Aug 2010
    Posts
    1
    I had the same question. Thanks for clearing that up.

Posting Permissions

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