Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
We're having trouble with lob tables. When we used the lo_import command to export the data, we were able to do it correctly. When it created shell scripting, we saw that the update statement was being created multiple times for each row. Please check in the attachment which we using for import.
Please kindly help us to fix the issue ASAP.
might be the file am not able to update the shell script size is 193MB so will attach few screen shots
As you can see from the attached screenshot, there are multiple lines in the middle of the script. I'm seeing this again when I start shell scripting, and it's printing the row information from scratch.
Hi Darold,
Thank you for your supporting.
We're having trouble with lob tables. When we used the lo_import command to export the data, we were able to do it correctly. When it created shell scripting, we saw that the update statement was being created multiple times for each row. Please check in the attachment which we using for import.
Please kindly help us to fix the issue ASAP.
might be the file am not able to update the shell script size is 193MB so will attach few screen shots
As you can see from the attached screenshot, there are multiple lines in the middle of the script. I'm seeing this again when I start shell scripting, and it's printing the row information from scratch.