The fastest way to migrate data (even CLOBs/BLOBs/RAW columns) from oracle to PPAS (advanced server) is to use dblink ora.
dblink_ora is bundled and installed as part of the Advanced Server database installation and one can configure and migrate data much faster.
For information about dblink_ora, please see the Database Compatibility for Oracle Developer's Guide, available at:
http://www.enterprisedb.com/products-services-training/products/documentation
However one can use -lobBatchSize <positive#> in order to execute the JDBC in batches, if the row size is of limited size (i.e. one batch can fit in the avaliable memory). Otherwise by default the batch migrates one row at a time incase table has LOBs/RAW column.
The fastest way to migrate data (even CLOBs/BLOBs/RAW columns) from oracle to PPAS (advanced server) is to use dblink ora.
dblink_ora is bundled and installed as part of the Advanced Server database installation and one can configure and migrate data much faster.
For information about dblink_ora, please see the Database Compatibility for Oracle Developer's Guide, available at:
http://www.enterprisedb.com/products-services-training/products/documentation
However one can use -lobBatchSize <positive#> in order to execute the JDBC in batches, if the row size is of limited size (i.e. one batch can fit in the avaliable memory). Otherwise by default the batch migrates one row at a time incase table has LOBs/RAW column.
Thank you so much!
Great information!!