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: Does Oracle Have a Way to Store Historical Changes to Records?

Re: Does Oracle Have a Way to Store Historical Changes to Records?

From: Mark Malakanov <markmal_at_rogers.com>
Date: Sat, 06 Aug 2005 13:01:20 -0400
Message-ID: <eaSdnZ2dnZ2WjRL2nZ2dnUNxad-dnZ2dRVn-zJ2dnZ0@rogers.com> 





GeoPappas wrote:


> Mark:

> 

> Thanks for your reply.  I know that I didn't mention it, but there is a

> requirement to be able to keep the data for quite a while (possibly

> years).  So Log Miner doesn't look feasible from this perspective.

> 

> 

> GeoPappas

> 



You still can use LM. Select periodically from LM views and store to 
your permanent history table. In this case you dont need to have triggers.
Received on Sat Aug 06 2005 - 12:01:20 CDT












Original text of this message













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