Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Mumbai,India.
    Posts
    36

    Unanswered: Where and how can i get the history of a data

    Hi,

    Where and how can i get the history of a data present in the table like
    the time of that data got inserted ,the time of that data got updated,etc..

    Is there any log file keeping these in Oracle?
    Yes,,then how can i get it?

    Thanks in advance....

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Where and how can i get the history of a data

    No, you have to maintain your own history, e.g. adding columns created_by, created_date etc. to the tables and using triggers to populate them.

Posting Permissions

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