exclude add partition

Robeen

Oracle DB 12.1.0.2

Solaris 11

Striim as ETL tool (GG trail Reader)

Hello Team,

we are doing replication from Oracle to Kudu. DDl replication is not supported from Oracle to Kudu since they are heterogeneous env. Otherwise replication will result in error.

I have added the following parameter in the extract.

EXTRACT EXTDWH

USERIDALIAS oggscb_dwh

DDL INCLUDE MAPPED &

EXCLUDE OPTYPE ALTER OBJTYPE 'TABLE' INSTR 'ADD PARTITION'

Do you think it is a good option?

Thanks,

Roshan

ORASCN

Hi,

This is an heterogeneous replication and replication is not supported. In this case, you should't use DDL parameter at all.

Yes, it will.

Regards,

Veera

Robeen

ORASCN

Hi Roshan,

EXTRACT EXTDWH

USERIDALIAS oggscb_dwh

DDL INCLUDE MAPPED &

EXCLUDE OPTYPE ALTER OBJTYPE 'TABLE' INSTR 'ADD PARTITION'

By default DDL replication is not enabled in Extract process. So what is the need of having DDL INCLUDE MAPPED parameter in here?

Regards,

Veera

Robeen

Hi,

should I remove the MAPPED statement?

If I precreate the partitions on the table, will data continue to insert inthe table?

Thanks,

Roshan

ORASCN

Hi,

This is an heterogeneous replication and replication is not supported. In this case, you should't use DDL parameter at all.

Yes, it will.

Regards,

Veera

Robeen

Hi Veera,

in this case I will use only

EXCLUDE OPTYPE ALTER OBJTYPE 'TABLE' INSTR 'ADD PARTITION'

in the extract, else replication to Kudu will fail.

Thanks,

Roshan

Robeen