Re: filter used tables out of complex script

If they are all create statements and not just selects you could just create a new user and run all of the scripts in that users schema, when you have finished the tables that are in that schema should be what was created by your reports. I would do this in a test system of course. If you also have selects, then its harder..:-(

Depending on how many scripts you have maybe its just easier to read them all and extract the table names that write programs to do it or pay for a commercial tool.

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.