1 2 Previous Next 20 Replies Latest reply: Mar 8, 2013 8:27 AM by Nicolas.Gasparotto Go to original post RSS
      • 15. Re: Find when was the table last updated ?
        sb92075
        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
          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
            Hi

            Anyone can answer my below query?
            • 18. Re: Find when was the table last updated ?
              995703
              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
                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
                  Old thread hijacking. And probably wrong forum to ask such a question.

                  +-- locking this thread --+

                  Nicolas.
                  1 2 Previous Next