Hi,

I want to extract the text field information of a table. I would then be importing the data to Oracle.

I tried the unload command. With the extracted information using unload utility, I am not able to load into Oracle.

What are the other possible ways of exporting the table that has a "TEXT" column?

Please help. Thanks in advance.

Hi,

when you use "unload", you put the result of your select command into an ascii pipe delimited file, supposedly the most compatible format ever for a data transfer. You might have a character codeset issue when importing your data.

unload is the simplest way to export data, and other tools won't be of any help in your case.

try to be more specific on the error given by Oracle, I am sure people here will help more efficiently.

eric

try to be more specific on the error given by Oracle