Migrating RAW Column Data from Oracle

SOLVED
Highlighted
Community Manager

Migrating RAW Column Data from Oracle

Hi All,
 
Sharing a new question I heard.....
"What is the fastest way to migrate RAW column data from Oracle to postgres or advanced Server?"
 
Looking for some advise please.

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
EDB Team Member

Re: Migrating RAW Column Data from Oracle

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.

 

View solution in original post

2 REPLIES 2
Highlighted
EDB Team Member

Re: Migrating RAW Column Data from Oracle

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.

 

View solution in original post

Highlighted
Community Manager

Re: Migrating RAW Column Data from Oracle

Thank you so much!

 

Great information!!

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks