0

How to copy a table from one database to another?

I am trying to create a PF which actually copies the table from one database to the other and then I was planning to schedule this PF daily to pickup only new records. But when I try to copy the initial load records, i receive a Garbage collection limit exceeded error. Looks like it is going out of memory due to large number of records. What can be done? The launcher.properties have already been updated with more memory as follows:

#Kernel JVM parameters
KN:JVM: -Xms1024M -Xmx3072M -Xrs -XX:PermSize=64M -XX:MaxPermSize=128M

Would it be advisable to increase more space? Or is there any other way of solving this.

1 comment

Please sign in to leave a comment.