CLOB issues
Posted: Thu Jun 23, 2011 4:04 am
Hi
I need to move 2.5 million records per day from one oracle DB to another oracle DB.
The source and target table are the same
The tables have 3 CLOB fields all of them must move to the targent
After reading the forum and IBM docs I defined a parallel job with 2 oracle connectors. The only way I can make the job to run is by keeping only one CLOB column
But still the job runs in an outrageous rate (20 rps)
So I have 2 questions:
1. How can I load more than one CLOB in the same process?
2. How can I increase the processing rate?
Thanks
I need to move 2.5 million records per day from one oracle DB to another oracle DB.
The source and target table are the same
The tables have 3 CLOB fields all of them must move to the targent
After reading the forum and IBM docs I defined a parallel job with 2 oracle connectors. The only way I can make the job to run is by keeping only one CLOB column
But still the job runs in an outrageous rate (20 rps)
So I have 2 questions:
1. How can I load more than one CLOB in the same process?
2. How can I increase the processing rate?
Thanks