-- determine changing time of record

[Andre]

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

[sybrandb@yahoo.com]

Re: -- determine changing time of record

avanrossem@hotm ail.com (Andre) wrote in message news:<4d32d1be. 0306292241.38bb dd1d@posting.go ogle.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

[rob]

Re: -- determine changing time of record


<sybrandb@yahoo .comschreef in bericht
news:a1d154f4.0 306300047.3fa77 00@posting.goog le.com...

avanrossem@hotm ail.com (Andre) wrote in message

news:<4d32d1be. 0306292241.38bb dd1d@posting.go ogle.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

[Mark D Powell]

Re: -- determine changing time of record

sybrandb@yahoo. com wrote in message news:<a1d154f4. 0306300047.3fa7 700@posting.goo gle.com>...

avanrossem@hotm ail.com (Andre) wrote in message news:<4d32d1be. 0306292241.38bb dd1d@posting.go ogle.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 --

[sybrandb@yahoo.com]

Re: -- determine changing time of record

avanrossem@hotm ail.com (Andre) wrote in message news:<4d32d1be. 0306302131.3789 8461@posting.go ogle.com>...

Mark.Powell@eds .com (Mark D Powell) wrote in message news:<2687bb95. 0306300517.2ecf 40a@posting.goo gle.com>...

sybrandb@yahoo. com wrote in message news:<a1d154f4. 0306300047.3fa7 700@posting.goo gle.com>...

avanrossem@hotm ail.com (Andre) wrote in message news:<4d32d1be. 0306292241.38bb dd1d@posting.go ogle.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

[Peter Shankey]

Re: -- determine changing time of record

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" <avanrossem@hot mail.comwrote in message
news:4d32d1be.0 306292241.38bbd d1d@posting.goo gle.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

[Andre]

Re: -- determine changing time of record

sybrandb@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