Export LOB objects with size greater than 64K

General
Enthusiast

Export LOB objects with size greater than 64K

We want to offload LOB objects from Teradata tables where  size is greater than 64K.I am trying to evaluate all the options at disposal here.

  1. Does FastExport utility support offloading greater than 64K?
  2. Will Teradata TPT be able to export where size becomes more than 64K?
  3. Are there any third party tools/utilities for this purpose.If yes please name a few?
  4. Can we write an application using JDBC(Java)/ODBC(C/C++) to achieve this?

Which of the above options would be best in terms of performance?Any other suggestions are also welcome..

Regards,

Indranil Roy

1 REPLY
Junior Supporter

Re: Export LOB objects with size greater than 64K

Hi.

1. No.

2. Yes.

3. SQL Assistant and TD Studio can export LOB files.

4. Yes.

 

It depends on many factors, but IMHO TPT may be the best option.

 

HTH.

 

Cheers.

 

Carlos.