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

Thread: Table re-design

  1. #1
    Join Date
    Jul 2006
    Posts
    2

    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.

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