I am using Oracle9i.
In my application, a table needs to re-design to scope with new user requirements. I need to add two more fields. The tables in DB are originally designed by my ex-colleague. There are no detail documents about the DB. So, I am afraid that there will be dependency problem after adding two new fields.The re-designed table is using by other tables, packages..
How can I find the dependency of the re-disgned table?
If you look in <oracle_home>\rdbms\admin there is a script called utldtree.sql that you can run that will create a procedure called DEPTREE_FILL. You can then execute this against a particular schema/object to find dependencies.