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)