Problem with TEXT in Datatype LONG

From: Joerg Reiner <reiner_at_gsf.de>
Date: 1998/10/29
Message-ID: <36383063.AAF970A4@gsf.de>#1/1

Hello,

I think I have a really basic problem about the ORACLE Data Types specially LONG.

I want to import ASCII Text into ORACLE LONG-Fields. Is there any limitation about the Text Length? As I new there can be up to 2^31 Bytes in there.
But the IMPORT-Tool give an length error message like the following:

--> Record 3: Rejected - Error on table "UMLSADMIN"."MRDEF1", column DEF.
--> Field in data file exceeded maximum specified length

The physical line length at this record is just 546 Characters.

So my question: What goes wrong there.

Hope Anybody could help me

Thanks a lot, Joerg

             GSF, Forschungszentrum fuer Umwelt und Gesundheit
             Medis Institut fuer medizinische Informatik und Systemforschung
             Forschungsgruppe (M1) Methoden der Kuenstlichen Intelligenz

     _/_/_/_/_/    _/_/_/_/_/    Dipl.-Inf. Dipl.-Ing. Joerg Reiner
            _/    _/      _/
           _/    _/_/_/_/_/      Muenchen - Neuherberg
          _/    _/_/             Ingolstaedter Landstr. 1
    _/   _/    _/  _/            D-85764 OberschleiÃŸheim

_/_/_/ _/ _/

                                 Priv.: jreiner_at_t-online.de


--------------------------------------------------------------------------

Received on Thu Oct 29 1998 - 00:00:00 CST