This discussion is archived
1 2 Previous Next 20 Replies Latest reply: Mar 8, 2013 6:27 AM by Nicolas.Gasparotto Go to original post RSS
  • 15. Re: Find when was the table last updated ?
    sb92075 Guru
    Currently Being Moderated
    SQL> select current_scn from v$database;
    
    CURRENT_SCN
    -----------
        2509975
    
    SQL> select distinct ora_rowscn from hr.emp;
    
    ORA_ROWSCN
    ----------
       1133049
    
    SQL> select scn_to_timestamp(ora_rowscn) from hr.emp;
    select scn_to_timestamp(ora_rowscn) from hr.emp
           *
    ERROR at line 1:
    ORA-08181: specified number is not a valid system change number
    ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1
    This DB has no "recorded" history when 1133049 occurred.
  • 16. Re: Find when was the table last updated ?
    937973 Newbie
    Currently Being Moderated
    Hi Osama

    I will be replying in this thread ,what i understood after reading is even if we enable the audit or trail on the table it will only keep a track if the ap_batches_all table is updated ,selected or anything is inserted into the table

    But my issue is there is a batch in oracle which was created with certain number of invoices ,and then on a later date few more invoices were added in that batch(table on which invoices were added is ap_invoices_All) but it did not update the last_update_date column of ap_batches_all table.

    Invoices are getting added to ap_invoices_all table ,but since they are a part of the batch a (batch is a combination of invoices) it should have been updated ,thats my concern.
  • 17. Re: Find when was the table last updated ?
    937973 Newbie
    Currently Being Moderated
    Hi

    Anyone can answer my below query?
  • 18. Re: Find when was the table last updated ?
    995703 Newbie
    Currently Being Moderated
    Hi friends,

    My name is giridhar. i have a doubt,please clarify me.

    can we write a single trigger of all tables in the database.

    I want to write a java program that captures changes(update,insert,delete) made to every table in the database.

    can we do that,is that possible through java program.

    please help me.

    Thankyou
  • 19. Re: Find when was the table last updated ?
    sb92075 Guru
    Currently Being Moderated
    992700 wrote:
    Hi friends,

    My name is giridhar. i have a doubt,please clarify me.

    can we write a single trigger of all tables in the database.

    I want to write a java program that captures changes(update,insert,delete) made to every table in the database.

    can we do that,is that possible through java program.

    please help me.

    Thankyou
    not possible
  • 20. Re: Find when was the table last updated ?
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    Old thread hijacking. And probably wrong forum to ask such a question.

    +-- locking this thread --+

    Nicolas.
1 2 Previous Next