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 6 3136 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
<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 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 -- 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
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 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: David C. Barber |
last post by:
I'm trying to determine which user has locked a given record from VB6.
I know I can use sp_lock and sp_who, and match up the data to determine
which users have locked records in my database,...
|
by: Web Webon |
last post by:
Hi everybody!
I wonder if this is possible?
I need to determine if a client is using "windows classic folders" or
anything else. If I instantiate a Shell ActiveX object is there a way
of...
|
by: StenKoll |
last post by:
Help needed in order to create a register of stocks in a company. In
accordance with local laws I need to give each individual share a
number. I have accomplished this by establishing three tables...
|
by: MS |
last post by:
What's the best way to "store" and display a value in a text box that
changes from day to day. An example of this would be where the name of the
user is manually typed in after using the datbase,...
|
by: Jim M |
last post by:
Two questions:
1) I have a scheduling application (Access 2002) that allows multiple
staff members to edit notes on their meetings and appointments from
their offices. A receptionist views a...
|
by: deko |
last post by:
I have a popup form with a textbox that is bound to a memo field. I've been
warned about memo fields so I'm wondering if I should use this code. Is
there any risk with changing the form's...
|
by: MLH |
last post by:
Suppose, in a multi-user environment, you
have append query SQL in a VBA procedure
that looks like INSERT INTO MyTable...
and the next line reads MyVar=DMax("","MyTable...
You can never be...
|
by: Andre |
last post by:
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...
|
by: Giampaolo Rodola' |
last post by:
Hi,
I'd like to know if there's a way to determine which is the best
buffer size to use when you have to send() and recv() some data over
the network.
I have an FTP server application which, on...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |