Cannot tell how table getting it's data!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Cannot tell how table getting it's data!

  1. #1
    Join Date
    Dec 2007
    Posts
    9

    Cannot tell how table getting it's data!

    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:


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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you cannot

  3. #3
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Probbably you need to start program which inserts data into the table ...
    Best wishes!
    Dmitri

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Dec 2007
    Posts
    9
    OK thanks.

  6. #6
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    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.

  7. #7
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    Quote Originally Posted by JMac View Post
    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"...
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width