golden gate replication

[Roshan]

Oracle Database 19c
RAC 2 nodes Exadata.

Hello Erman,

hope you are fine.

I would like to move a table from 1 tablespace to another tablespace using Oracle GoldenGate. I have a few questions regardning this:

should I specify RMTHOST in pump if both instances(source and target) are running on same host?

can the target table be created using CTAS parallel or insert append with parallel hints? Data pump export/import will be too slow for tables with CLOB/XMLTYPE.

Is the flashback_scn import in export? If I plan using CTAS/insert append, there will be no flashback_scn.

When I use CTAS, I see parallel sessions with degreee I specified in CTAS command

SELECT * FROM gv$px_session WHERE sid IN (
  SELECT sid FROM gv$session WHERE username = 'T24PROD');

but when I use RDBMS redefinition I see only 2. It does not pick up the parallel sessions.

Kindly advise.

Regards,
Roshan

[ErmanArslansOracleBlog]

should I specify RMTHOST in pump if both instances(source and target) are running on same host?
*it is not a must.

can the target table be created using CTAS parallel or insert append with parallel hints? Data pump export/import will be too slow for tables with CLOB/XMLTYPE.
*we use Datapump (in parallel).. Why do you think CTAS will be faster?

*When I use CTAS, I see parallel sessions with degreee I specified in CTAS command but when I use RDBMS redefinition I see only 2. It does not pick up the parallel sessions?

I don't know why you are using dbms_redefinition in this context but! see ->
Parallel Online Redefinition For LOB Table (Doc ID 2315184.1)