Re: Generate a CRUD matrix

From: GA <grahamallan60_at_hotmail.com>
Date: Thu, 27 Feb 2003 22:25:09 -0000
Message-ID: <3e5e9261$0$6300$cc9e4d1f@news.dial.pipex.com>

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.
Received on Thu Feb 27 2003 - 16:25:09 CST