Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can i select the new(or newly updated) records if there is no timestamp filed in my table?

Re: How can i select the new(or newly updated) records if there is no timestamp filed in my table?

From: <ronplank_at_my-deja.com>
Date: Fri, 12 Jan 2001 16:10:42 GMT
Message-ID: <93na9o$i3g$1@nnrp1.deja.com> 






In article <93j8so$8hk$1_at_license1.unx.sas.com>,
  "newshost.unx.sas.com" <bill.ding_at_sas.com> wrote:


> How can i select the new(or newly updated) records if there is no

 timestamp


> filed in my table of Oracle Database?

>

> Are there any Oracle system options that i can trace these records?Or

 exist


> other tools to help me?

>

> Thanks,

>

> Bill Ding,

> Oracle Developer

>



You might look into Oracle's Audit features.
But that will only help after the audit features are turned on



Good Luck


Ron Plank


>





Sent via Deja.com


http://www.deja.com/
Received on Fri Jan 12 2001 - 10:10:42 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US