Background: Oracle 9.2.0 running on win2k
q1: I need to find out which objects have not been in used for > 6 mths. How do i do this?
q2: Before i delete an object, eg, an index, materialized view, view, i need a query to find what are its dependency, so that i would know whether this shld be deleted
q3: i also need to know which view, index, table (any object, object-type) is being referenced in a program (PL/SQL, C++). Anyway to run a query that would list this info