I have an "Oracle 9i" table which was getting data once everyday till July 12. But since July 12 no data has been inserted into the table. The irony is I don't know how this table is/was getting it's data. I have tried the following queries but to no avail:
I have an inclin towards a procedure doing the job but cannot see any such procedure inserting data into TAB1 or scheduled in the crontab.Code:select * from dba_dependencies where referenced_name like '%TAB1%'; select * from user_dependencies where referenced_name like '%TAB1%'; SELECT * FROM USER_SOURCE WHERE TEXT LIKE '%TAB1%'; select * from v$sql where SQL_TEXT like '%TAB1%'
Could someone kindly advise on any more methods to find out how TAB1 is/was getting poplulated with data?