Moving LOB Data from one Teradata Database Table to Another
To move LOB data from one Teradata Database table to another, a Teradata PT script must use:
Using the Inline Method
If you want to use the inline method for the job, you must define the LOB columns as BLOB (lengthBytes) or CLOB (lengthBytes), according to their data content, in the schema.
Using the Deferred Method
If you want to use the deferred method for the job, you must define the LOB columns as BLOB (lengthBytes) AS DEFERRED BY NAME or CLOB (lengthBytes) AS DEFERRED BY NAME, according to their data content, in the schema.
You should be aware of the following events during the job run:
<file-basename>_<column-name>_<job-id>_p<#>_r<#>.<file-extension>
where
These LOB data files will be deleted immediately after their data has been inserted into the target table.
For a sample Teradata PT script in the sample/userguide directory:
uguide18.txt: Exporting BLOB/CLOB Data from One Teradata Database Table and Loading It into Another.