Find dependencies for all tables within a schema
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.