Oracle-L: Re: List of Rows Updated

From: Tom Pall <tpall_at_realtime.net>
Date: Tue, 29 Oct 2002 07:14:25 -0800
Message-ID: <F001.004F63AC.20021029071425@fatcity.com>

RE: List of Rows UpdatedGosh. I wish I worked in your shop. I'm typically asked to produce an audit report for yesterday on a table I didn't even know existed. "What do you mean you can't do that? Aren't you an Oracle DBA?"

Original Message ----- From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 29, 2002 5:58 AM Subject: RE: List of Rows Updated

Auditing is much simpler and usable than logminer for *this purpose*.

Raj

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
From: Tom Pall [mailto:tpall_at_realtime.net] Sent: Tuesday, October 29, 2002 1:39 AM To: Multiple recipients of list ORACLE-L Subject: Re: List of Rows Updated

Logminer comes to mind.

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, October 28, 2002 10:23 PM

> Hi,
> I want to get the list of rows which were updated(then commited) in a
> particular table say X on a specific date e.g yesterday.
> Is this possible and how ?
>
> Thanks
> Manoj.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tom Pall
  INET: tpall_at_realtime.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Oct 29 2002 - 09:14:25 CST