Helpful information and examples on how to use SQL Server Integration Services.
This video presentation Rakesh Parida (MSFT) demonstrates how to perform CDC for Oracle databases using SSIS 2012. You'll learn how the CDC features work, how to create and administer the CDC service, as well as how to use logs and traces to troubleshoot the service.
The video is availble online at http://technet.microsoft.com/en-us/sqlserver/jj218898.aspx .
For more information about the CDC for Oracle, see the CDC for Oracle in SQL Server 2012 blog post by Rakesh.
Must have ALTER DATABASE privilege on the Oracle target. Only will find that out after much effort has been expended.