Home » Server Options » Streams & AQ » Oracle stream does not replicate DML and DDL changes
Oracle stream does not replicate DML and DDL changes [message #75719] Thu, 08 July 2004 06:36 Go to next message
Amit Mohanty
Messages: 2
Registered: November 2001
Junior Member
Source DB is Oracle 9i on AIX.

I am trying to replicate data to oracle 9i database which is on windows 2000.

I followed all steps as prescribed by OEM and I am able to see that the capture is happening. The state is always "Capture Changes" though. Then nothing gets applied to the target database.

At this point it also shows "Total messages enqueued is 5". Does this mean that the capture is happening properly but not the apply?

Any idea on how to take care of this situation?

Thanx,

Amit

 

 

 
Re: Oracle stream does not replicate DML and DDL changes [message #75726 is a reply to message #75719] Mon, 26 July 2004 03:07 Go to previous message
Harish Shanbhag
Messages: 19
Registered: July 2004
Junior Member
We solved by recreating the apply object.
otherwise apply hextoraw(16) using select statement.
just check documentation.
Previous Topic: Broken database link
Next Topic: Oracle streams used in two different OS
Goto Forum:
  


Current Time: Thu Mar 28 05:52:33 CDT 2024