How to find all database objects that access a specific table column???
orchidSep 21 2011 — edited Sep 22 2011Greetings 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.