Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: where is a field used

    Is there something in OEM or TOAD that would tell me which TRIGGERS/VIEWS/PACKAGES were using a particular field? We're looking at dropping a field from a table, and we need to clean up everything related.

    I don't mind writing something against DBA_SOURCE, but I didn't want to if the work had been done already by a tool we currently own.

    -Chuck
    10gR1

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Don't know if such a thing exists, allthough I hardly use TOAD. However, I would be surprised if they didn't use *_source to found out this information.

  3. #3
    Join Date
    Oct 2004
    Location
    Oklahoma City OK -
    Posts
    122
    Look under TOAD menu item, 'TOOLS', 'OBJECT SEARCH'.

    I am using version 7.6.0.11

  4. #4
    Join Date
    Dec 2003
    Posts
    1,074
    Sweet, that works perfect, in TOAD 8.6.
    -cf

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •