GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Replicat and Interval Partitioned Table

edited Mar 4, 2016 4:10AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hi Gurus,

I have a big doubt on replicat process and interval partitioned table.

On a source  database I have a couple of range partitioned table. Now these tables must be added to OGG replication.

Customer doesn't want to enable o configure OGG for DDL operation, so It's not possibile to manage automatically the split/add new partition on target.

One of the solutions could be to add a numbers of partitions on target more than source tables and do some maintenance during the year to add new future partitions (stopping GG processes)

I think that an alternative could be to use interval partition on target database. I know that interval partition is support, but not the system generated partition

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center