Re: Streams advice

On Tue, 21 Aug 2007 14:03:45 -0700, DA Morgan <damorgan_at_psoug.org> wrote:

>And here comes the fun.
>
>You are going from a RAC cluster which means each and every node has its
>own redo log thread which means you need to have streams running on each
>node.

Not according to Metalink
>
>Unless you have some need for the complexity of
>publish-transform-subscribe I'd take a serious look at using Change
>Data Capture. It is far easier to implement. Also make sure that you
>do the following:
>
>alter database force logging;
>alter database add supplemental log data;
>--

Is Change Data Capture available in 9i? Don't think so.

Yes, I am facing to 'synchronize' two 9i databases, where half of the tables have no PK...

-- 
Sybrand Bakker
Senior Oracle DBA