Database Administration (MOSC)

MOSC Banner

Find dependencies for all tables within a schema

edited Jul 18, 2014 5:00AM in Database Administration (MOSC) 9 commentsAnswered

I have this schema that has over 1,000 tables and I need to run some type of query/script to check each table within a schema as to whether or not it has a dependency.


Please note, I was able to do this successfully per one table at the time using [ deptree_fill ] utility below. But, there is no way I can do this for all 1,000 tables one at the time


deptree_fill('table', 'HR', 'payroll_hr');

SQL> select * from ideptree

I'd appreciate your input if there is a quick way to do this for all tables within a schema..

Thank you.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center