Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2011
    Posts
    3

    Unanswered: Extracting "TEXT" column of a table in Informix

    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.

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    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

  3. #3
    Join Date
    Sep 2011
    Posts
    1
    try to be more specific on the error given by Oracle

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •