By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,322 Members | 1,182 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,322 IT Pros & Developers. It's quick & easy.

-- determine changing time of record

P: n/a
Hello all,

In my database I have a table with records. (Yes I have!!)
Last week a record is changed, but I want to know on which date/time
that was.
Is there a oracle field in the table (like rownum) in which I can see
the time which the recoird has changed??

(please do not answer with the sollution to add an extra "field" in
the table and let a trigger fill that field with the changingdate. It
is too late for that :-) )
THANKS and regards,
Andre
The Netherlands
Jul 19 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
av********@hotmail.com (Andre) wrote in message news:<4d**************************@posting.google. com>...
Hello all,

In my database I have a table with records. (Yes I have!!)
Last week a record is changed, but I want to know on which date/time
that was.
Is there a oracle field in the table (like rownum) in which I can see
the time which the recoird has changed??

(please do not answer with the sollution to add an extra "field" in
the table and let a trigger fill that field with the changingdate. It
is too late for that :-) )
THANKS and regards,
Andre
The Netherlands

Please don't ask for advice if you don't want to implement the obvious
and *ONLY* solution. Your remark 'it is too late for that' is just
what is: ridiculous and utter bs. Tables can be ALTERed easily, and
nothing will be affected by that: RDBMS lesson !1!. Triggers can also
be added easily.

Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #2

P: n/a
rob

<sy******@yahoo.com> schreef in bericht
news:a1*************************@posting.google.co m...
av********@hotmail.com (Andre) wrote in message

news:<4d**************************@posting.google. com>...
Hello all,

In my database I have a table with records. (Yes I have!!)
Last week a record is changed, but I want to know on which date/time
that was.
Is there a oracle field in the table (like rownum) in which I can see
the time which the recoird has changed??

(please do not answer with the sollution to add an extra "field" in
the table and let a trigger fill that field with the changingdate. It
is too late for that :-) )
THANKS and regards,
Andre
The Netherlands

Please don't ask for advice if you don't want to implement the obvious
and *ONLY* solution. Your remark 'it is too late for that' is just
what is: ridiculous and utter bs. Tables can be ALTERed easily, and
nothing will be affected by that: RDBMS lesson !1!. Triggers can also
be added easily.


If he wants to know the date/time a record was changed *LAST WEEK* putting a
trigger on that table *NOW* won't give him the answer.
If you are running archive log mode the "log miner" may be able to give you
the answer.

Rob
Jul 19 '05 #3

P: n/a
sy******@yahoo.com wrote in message news:<a1*************************@posting.google.c om>...
av********@hotmail.com (Andre) wrote in message news:<4d**************************@posting.google. com>...
Hello all,

In my database I have a table with records. (Yes I have!!)
Last week a record is changed, but I want to know on which date/time
that was.
Is there a oracle field in the table (like rownum) in which I can see
the time which the recoird has changed??

(please do not answer with the sollution to add an extra "field" in
the table and let a trigger fill that field with the changingdate. It
is too late for that :-) )
THANKS and regards,
Andre
The Netherlands

Please don't ask for advice if you don't want to implement the obvious
and *ONLY* solution. Your remark 'it is too late for that' is just
what is: ridiculous and utter bs. Tables can be ALTERed easily, and
nothing will be affected by that: RDBMS lesson !1!. Triggers can also
be added easily.

Sybrand Bakker
Senior Oracle DBA


Sybrand provided the only practical solution on an ongoing basis;
there is another possibility if your system is in archive log mode and
you still have the archived redo logs. You can use the log minger
facility to look for the change. It will be a time consuming pain,
but if the time when this specific record was changed is a critical
issue then it may be an option.

HTH -- Mark D Powell --
Jul 19 '05 #4

P: n/a
av********@hotmail.com (Andre) wrote in message news:<4d**************************@posting.google. com>...
Ma*********@eds.com (Mark D Powell) wrote in message news:<26*************************@posting.google.c om>...
sy******@yahoo.com wrote in message news:<a1*************************@posting.google.c om>...
av********@hotmail.com (Andre) wrote in message news:<4d**************************@posting.google. com>...
> Hello all,
>
> In my database I have a table with records. (Yes I have!!)
> Last week a record is changed, but I want to know on which date/time
> that was.
> Is there a oracle field in the table (like rownum) in which I can see
> the time which the recoird has changed??
>
> (please do not answer with the sollution to add an extra "field" in
> the table and let a trigger fill that field with the changingdate. It
> is too late for that :-) )
>
>
> THANKS and regards,
> Andre
> The Netherlands
Please don't ask for advice if you don't want to implement the obvious
and *ONLY* solution. Your remark 'it is too late for that' is just
what is: ridiculous and utter bs. Tables can be ALTERed easily, and
nothing will be affected by that: RDBMS lesson !1!. Triggers can also
be added easily.

Sybrand Bakker
Senior Oracle DBA


Hello Sybrand, I think you did not fully understand my question.
Offcourse I know that tables can be easily altered, but thats not my problem.

I will try the data mining method. Takes a lot of time, but I will try.
Andre

crap methods are crap methods and not changing an application for
political reasons is just stupid.

Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #5

P: n/a
I have not used it before, but it is my understanding that you can use 'Log
Miner'. Log Miner I believe comes with 8i and up. Also I believe it is
required the database to be in archivelog mode. My advice would be to go to
OTN and find the docs on it.
"Andre" <av********@hotmail.com> wrote in message
news:4d**************************@posting.google.c om...
Hello all,

In my database I have a table with records. (Yes I have!!)
Last week a record is changed, but I want to know on which date/time
that was.
Is there a oracle field in the table (like rownum) in which I can see
the time which the recoird has changed??

(please do not answer with the sollution to add an extra "field" in
the table and let a trigger fill that field with the changingdate. It
is too late for that :-) )
THANKS and regards,
Andre
The Netherlands

Jul 19 '05 #6

P: n/a
sy******@yahoo.com wrote in message >
crap methods are crap methods and not changing an application for
political reasons is just stupid.


Yeah, you are right, But crap methods build by others??
You have to live with it :-)

Thanks and regards,
Andre
Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.