DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12
  1. #11
    Join Date
    Nov 2000
    How about putting a trigger on the table? I know there is no trigger for SELECT, but then what are the odds that the app does a SELECT but never an insert, update or delete?

    make your trigger do this

    if :new.column_of_interest <> :old.column_of_interest then
    insert a row into some table for monitoring;
    end if;

  2. #12
    Join Date
    Sep 2000
    If you are going for the all the user tables in the database then you are in for Trouble.

    But for a specfic table means you can try by
    1.sql_trace on
    2.sql_text ananlysis
    3.Try using the New Monitoring option for tables.

    Identify the columns that you want to eleiminate.create a view on all the columns that you need .Test your application .

    Then drop all the columns .This is going to be a pain.

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.