Skip to Main Content

Oracle Database Discussions

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 all database objects that access a specific table column???

orchidSep 21 2011 — edited Sep 22 2011
Greetings All,

I modify a column attribute of a table by changing the label and data, from ssn to emp_id. Now, I need to find out all the database objects that query, update and delete, etc this table column. I queried the existing column label, ssn, from the DBA_Source and only retrieved several rows. Is this sufficient to ensure I have found all the database objects that access the ssn table column?

Please let me know asap either I should continue my search the database or confirm my query from the SYS.DBA_Source table is sufficient to ensure I did not miss anything.

I am in need of help on this soon as I am approaching to my implementation deadline.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2011
Added on Sep 21 2011
3 comments
657 views