Re: Change Data Capture for Processes and not other databases
From: Kevin Jernigan <kevin.jernigan_at_oracle.com>
Date: Mon, 11 Mar 2013 07:39:34 -0700
Message-ID: <513DECA6.1090403_at_oracle.com>
Have you looked at Flashback Data Archive (fka Total Recall)? See here <http://docs.oracle.com/cd/E11882_01/appdev.112/e25518/adfns_flashback.htm#ADFNS01011>. -KJ
Date: Mon, 11 Mar 2013 07:39:34 -0700
Message-ID: <513DECA6.1090403_at_oracle.com>
Have you looked at Flashback Data Archive (fka Total Recall)? See here <http://docs.oracle.com/cd/E11882_01/appdev.112/e25518/adfns_flashback.htm#ADFNS01011>. -KJ
*Kevin Jernigan* (650) 607-0392 (o) *Senior Director Product Management* (415) 710-8828 (m) kevin.jernigan_at_oracle.com <mailto:kevin.jernigan_at_oracle.com> *Advanced Compression - ACO*: *Information Lifecycle Management* - ILM Advanced Row Compression *Temporal database* (Total Recall etc) Advanced LOB Compression *SecureFiles* Advanced LOB Deduplication *Database File System* - DBFS RMAN Backup Compression *Direct NFS Client* - dNFS Data Pump Export Compression *CloneDB* Data Guard Redo Network Transport Compression *Database Resource Manager* - DBRM Flashback Data Archive History Table Optimization *Continuous Query Notification* - CQN *Hybrid Columnar Compression* - HCC *Index Organized Tables* - IOT *Database Smart Flash Cache* *OISP*
On 3/11/13 7:27 AM, Dba DBA wrote:
> Oracle 11.2.0.3
> Is it possible to set up change data capture for queries? I can register
> something manually that says 'get new records with this value in this field
> from this table'? Would need multiple subscribers for each type.
> Would need the ability to go re-query data in case there is an issue
> passing the data downstream.
>
> I would settle for capturing the ROW_IDs of new records by 'type' and then
> querying a view or table of some sort based on those ROW_IDs.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 11 2013 - 15:39:34 CET