Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is there a tool which given a bunch of data extraction SQL scripts will produce a dependency graph? Basically given scripts which take input tables, create a bunch of interdependent intermediary tables and then create output tables and I would like to get some analysis done on it to know which tables depend on which.

share|improve this question
1  
Is there any chance you could turn the SQL scripts into stored procedures so that you (or a tool) can use Oracle's dependency tracking data dictionary views? Do you really need to create intermediate tables-- in Oracle, it's almost certainly better to create the tables once when you deploy your application and then to use them in your process-- if the table data is temporary, perhaps they should be global temporary tables. –  Justin Cave May 6 '12 at 18:08
    
@JustinCave this is an ETL process which is ran periodically. Pretty much everything is read only after the process is done, but intermediary tables are useful for all kinds of things –  MK01 May 8 '12 at 0:28
    
@MK01 - But why do the objects need to be created dynamically? Why can't you populate existing objects? Could the SQL scripts be converted into stored procedures? –  Justin Cave May 8 '12 at 0:31
    
Well, it could be populating existing objects. But I need to know which tables feed which tables. I suppose this could be converted into stored procedures, how does that help? What I want to know is that somewhere there is a statement "SELECT * FROM table1 INTO table2" then table2 depends on table1. –  MK01 May 8 '12 at 1:28
    
@jcolebrand look at my profile. Look at the questions. I didn't accept because none of the responses seemed to be worthy of an accept. –  MK01 May 10 '12 at 20:45
show 1 more comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.