Triggers-Monitoring Table Data transactions
Posted on 2004-09-30
Hi every1, Im absolutely and totally new in Oracle, just 4 days OLD:). Any ways I have a task to do I need your help. Here is the background, we are running on 8i, and we have an application developed(by some company) which is exclusively using this Database. All all i do is I just open the EnterPrise Management console and see the data and statistics of each table. BUT NOW I NEED SUMTHING ELSE, now I want to know and OBSERVE whenever any data is coming from the frontend (i.e the application), I need to know and monitor where the data is being saved , therefore before every insert of everytable I need a trigger to tell me that there is an Insert going to be done.
I asked this problem to sum1, he told me it can be done by triggers, I don't know where to write the trigger and how to execute it. Since Im totally anew bie, plz tell me is there any other way to monitor my table data, or if it is with triggers, plz tell me in step by step how to do it and where to write and how to save the trigger and how to execute........plz I NEED YOUR HELP GURU's........