GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Can GoldenGate replicate a Postgres table (with partition) to Oracle table (partitioned)?

Example:

Postgres table

CREATE TABLE TEST_PARTITION(

 COL1 NUMERIC(19,0) NOT NULL,

 COL2 VARCHAR(30) ,

CONSTRAINT PK_TEST_PARTITION PRIMARY KEY (COL1) ) ;

PARTITION BY HASH(COL1)

CREATE TABLE TEST_PARTITION_P00 PARTITION OF TEST_PARTITION FOR VALUES WITH (MODULUS 4, REMAINDER 0) ;

CREATE TABLE TEST_PARTITION_P00 PARTITION OF TEST_PARTITION FOR VALUES WITH (MODULUS 4, REMAINDER 1) ;

CREATE TABLE TEST_PARTITION_P00 PARTITION OF TEST_PARTITION FOR VALUES WITH (MODULUS 4, REMAINDER 2) ;

CREATE TABLE TEST_PARTITION_P00 PARTITION OF TEST_PARTITION FOR VALUES WITH (MODULUS 4, REMAINDER 3) ;


Oracle table

CREATE TABLE TEST_PARTITION (

 COL1 Number(10,0) NOT NULL,

 COL2 Varchar2(30) ,

CONSTRAINT PK_TEST_PARTITION PRIMARY KEY (COL1)

)

PARTITION BY HASH(COL1)

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center