-
Table re-design
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?
Thanks.
Cheers
BEERSA.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|