I have a Postgres 9.1 table plines with a bytea field shape.
Number of records is about 500000.
What is the best way to copy bytea data plines.shape from Postgres to a field shape of an Oracle 10g table olines?
Thank you in advance, ysa
I have a Postgres 9.1 table plines with a bytea field shape.
Number of records is about 500000.
What is the best way to copy bytea data plines.shape from Postgres to a field shape of an Oracle 10g table olines?
Thank you in advance, ysa
Copyright © 2021 Jogjafile Inc.
I'd create a program in Java which would connect to PostgreSQL (using JDBC PostgreSQL driver) and Oracle (using Oracle Instant Client) simultaneously and then read a row from Postgres, put this row to Oracle table, repeat.
This would be much easier the other way around... ;-)