It might seem an unconventional way to do export/import for data going by SQL-scripts. I did do it that way because csv does not seem to export clobs at least not with 12.0.5. Possibly this is an issue all by itself but it is not my point here.
I initially exported the clob files into the very same directory as the sql script. I decided then to move them to a subdirectory called clob and adapted the sql script prepending clob/ to the file name.
The import I wanted to do by a bookmarked script calling @run to run it outside the GUI. But this results in file not found error. While my doing might be highly irregular, but should work in my opinion. The original path to the clob files was relative and still is. But DbVis does look for them in the directory of the run script (Bookmarks) and not in the directory I changed to within the run script.
If this is intended behaviour, please let me know how I can load the data from the directory I put the files in. I do not want to pollute my Bookmarks folder.
Our products help over 24,500 customers in 144 countries
Roger Bjärevall
said
over 2 years ago
Hej Thiemo,
Just to inform you that this is now fixed in version 13 and in 12.1.9.
Easiest is that you open Help->Check for Update in DbVisualizer to perform the upgrade. An alternative is that you download from our website: https://www.dbvis.com/download/
Thiemo Kellner
Hej
It might seem an unconventional way to do export/import for data going by SQL-scripts. I did do it that way because csv does not seem to export clobs at least not with 12.0.5. Possibly this is an issue all by itself but it is not my point here.
I initially exported the clob files into the very same directory as the sql script. I decided then to move them to a subdirectory called clob and adapted the sql script prepending clob/ to the file name.
The import I wanted to do by a bookmarked script calling @run to run it outside the GUI. But this results in file not found error. While my doing might be highly irregular, but should work in my opinion. The original path to the clob files was relative and still is. But DbVis does look for them in the directory of the run script (Bookmarks) and not in the directory I changed to within the run script.
If this is intended behaviour, please let me know how I can load the data from the directory I put the files in. I do not want to pollute my Bookmarks folder.
Varma hälsningar
Thiemo