Using Oracle Streams For Data Replication CCB (Doc ID 808265.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version: 2.1.0 and later   [Release: 2.1 and later ]
Information in this document applies to any platform.

Goal

The below question refers to Oracle Utilities Customer Care and Billing version 2.1 on HP-UX Itanium with Oracle Database 10.2.0.2.

There is a single Production system that supports the online and batch input of data. For reporting there is a separate database that is refreshed on a daily basis. However, as the database is now getting very large, Oracle Streams should be implemented, to replicate the data.

Please advise if there are any objects in the CC&B standard schema that might not be replicated using Streams.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms