DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Table re-design

  1. #1
    Join Date
    Jul 2006

    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?



  2. #2
    Join Date
    Apr 2006
    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

Click Here to Expand Forum to Full Width

By using this site, you agree to the Privacy Policy