Re: Generate a CRUD matrix

GA wrote:

> David
>
> I am not aware of an automatic way of converting the results of a trace file
> to a CRUD diagram but the best way of converting the results of a trace is
> to use a program called tkprof. This is installed as part of the oracle
> install and so should be on you pc or server. Type tkprof at the command
> line, if it is installed you will get a list of instructions
>
> Regards
>
> Graham
>
> "David FitzGerald" <david_at_fitzg.com> wrote in message
> news:7f966bc5.0302271025.705648c5_at_posting.google.com...
> > I've been searching all day how to do this, but with no luck...
> >
> > Is it possible to generate a CRUD matrix from an Oracle 9i SQL trace
> > file?
> > If not, is it even possible to get a list of what tables have had
> > something selected from, updated or inserted?
> >
> > I'm new to all this, so please excuse if this is a stupid question...
> >
> > Thanks,
> > David.

TKPROF will be in the oracle bin directory.

Daniel Morgan Received on Thu Feb 27 2003 - 18:23:39 CST