ora2pg
ora2pg copied to clipboard
lo_import _table_name.sh script issue
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.