Archives of the TeradataForum
Message Posted: Wed, 17 Dec 2008 @ 16:29:22 GMT
I don't know how big your LOBs are but the max size of VARCHAR and VARBYTE in Teradata is larger than for most other databases. (Some are as small as 4K)
If your LOBs are smaller than 64K you might therefore want to consider the option of using those data types rather than LOBs. (This decision has its own pros and cons)
SQL Assistant is capable of importing larger LOBs, but this is not a bulk load tool (ie. It is slow) and it requires that each LOB be a file on the pc/server that is running the app.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|