i am trying to replicate sdo_geometry datatype object using oracle11gr2 streams but the capture process didnt capture the change made on the table.Thanks in advance for any help
Edited by: user9104539 on Nov 28, 2012 11:05 PM
User-defined types (including object types, REFs, varrays, and nested tables) is
Unsupported Data Types for Capture Processes
Refer the Oracle document
The docs reference metalink note 556742.1 which appears to contain a link to the software. That being said the note explicitly says:
Oracle Server - Enterprise Edition - Version 10.2.0.4 to 18.104.22.168 [Release 10.2 to 11.1]
Does anyone know if this also applies to 11.2 and the note isn't updated, or is there something already built in 11.2 for streams? The SQLApply note (949516.1) seems to imply it's built in for 11.2 but doesn't mention streams. The 11gR2 Docs still list 556742.1 so I guess I'd assume the note isn't updated.