SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find objects that reference a specific table and column - 11g R2

856765Apr 22 2011 — edited Apr 25 2011

Greetings,

I have been charged with dropping columns from a number of tables. I am trying to write a query that will return all the objects that reference these tables and columns. I have queried the USER_DEPENDENCIES and ALL_DEPENDENCIES tables but can only do so using the table name. To go through the all the pkgs, procs, etc, returned would prove quite time consuming. 'Find Database Objects' in PLSQL Developer is a time sink if I'm even using it correctly.

Any and all assistance is greatly appreciated.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 23 2011

Added on Apr 22 2011

#11g, #column, #query, #table

4 comments

8,636 views