Urgent Help - how to track from dictionaries when the view definitions have been redefined/recompiled

Dear oracle gurus,
My application is a java server which talks to oracle 8.1.7.4 server. This server dynamically creates tables and views of those tables. When creating views from the base tables, it elimintaed some unwanted columns.
Since we are exposing these views for reporting needs for the end customer, we decided to expose only certain columns.

All of a sudden, the view definitions changed and the reporting front end is broken. (Since I the creator of the code to create views did not change any thing, i am just wondering how the view definitions got redefined or recompiled)

My reporting front end is BusinessObjects which exposes all the views.

Any clue if i can track from the database, when the views and by whom they got recompiled/redefined.. it will be helpful for me to track. I am just few days away from releasing this reporting product to customer and so any clue will be helpful.

-thx,
avsrk Received on Thu Aug 21 2003 - 18:17:56 CDT