Cannot tell how table getting it's data!

[Shajju]

Hi guys

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:

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%'

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.

Could someone kindly advise on any more methods to find out how TAB1 is/was getting poplulated with data?

Many Thanks
Shajju

[davey23uk]

you cannot

[kgb]

Probbably you need to start program which inserts data into the table ...

[PAVB]

Assuming alert.log is not full of ORA- errors (since July 12) telling segment can't allocate more extents or something of the sort... I would pick up the phone and call applications team.

[Shajju]

OK thanks.

[JMac]

5 months with no data? And none of your users have complained (ie) giving you a clue as to what its used for and how it might be being populated ...

So what's your problem? It's obviously not important.

[gandolf989]

5 months with no data? And none of your users have complained (ie) giving you a clue as to what its used for and how it might be being populated ...

So what's your problem? It's obviously not important.

Hey Red Boy... I curious about why you replied to this thread. I know that this site has not gotten much traffic lately,
but it was a two year old post. Unless Davey23uk deleted the post from whoever dredged this up. Hence it doesn't
make any sense. Kind of like saying "Robert's your father's brother"...