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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.