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

Hi,

One easy way to do this is to select from dba_objects, if you have access.

I created a view called DEPTVIEW to demonstrate. This query will give you

the user and the date it was created:

SQL> select owner,created from dba_objects where object_name = 'DEPTVIEW';

OWNER                          CREATED
------------------------------ ---------
SCOTT                          22-AUG-03

SQL> I hope this is helpful.

Steve

Subrahmanyam Arya wrote:

> 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 Fri Aug 22 2003 - 07:58:46 CDT