Skip links

Tag: 19c

GoldenGate Initial Load Using Datapump Import Performance Improvement for IOT with 1.9B rows

GoldenGate Initial Load Using Datapump Import Performance Improvement for IOT with 1.9B rows

in Tags

Datapump is used for Instantiating Oracle GoldenGate with an Initial Load. Client is facing performance issues with datapump for Index Organized Table (IOT) with approximately 1.9B rows. The root cause of the issue is source (DW) and target (OLTP) have different partition design for IOT.