1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

getting last modified table name

Discussion in 'SQL PL/SQL' started by member.forums@gmail.com, Jul 17, 2009.

  1. member.forums@gmail.com

    member.forums@gmail.com Active Member

    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    80
    Hi
    Is there any way I get the name of the table that was modified (updated / inserted into /deleted from ) as the result of the last query fires on database.
    I cannot enable db audit due to performance issues.

    Any help would be highly appreciated

    Thanks
    Sapan
     
  2. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    Yes, try the view all_tab_modifications after logging in as SYSTEM user.
     
  3. member.forums@gmail.com

    member.forums@gmail.com Active Member

    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    80
    Thanks Tyro

    I get it using substr and instr on the last query text stored in
    ora_sql_text for any operations insert update or delete