Re: Loading LONG data in SQLLoader

From: Michael T. Smith <mtsmith_at_us.oracle.com>
Date: Thu, 23 Dec 1999 08:11:00 -0600
Message-ID: <83t724$rfq$1@inet16.us.oracle.com>

The following should work:

        mylong.ctl:
                --  Long loader example.
                --   Records cannot exceed 65535 bytes in this form.
                --   The Primary Key is assumed to START in the 3rd column
                --      of the first line of the file and be terminated with
                --      a Ctrl-G (X'07').
                --    Ctrl-G is *NOT* allowed to appear anywhere else in the
                --      file.
                --
                LOAD DATA
                INFILE mylong.dat "fix 65535"
                  PRESERVE BLANKS
                INTO TABLE mylong
                  FIELDS TERMINATED BY X'07'
                ( pk position(3), dat char(65535) )

        and with a SQL*Loader command line of the form:

                sqlldr userid=scott/tiger bindsize=100000 control=mylong

Michael Smith

"Jonathan Sunderland" <jsunderland_at_pine-cone.com> wrote in message news:83stk1$196d$1_at_quince.news.easynet.net...
> I'm trying to load some flat files which have some text which I'd like to
> put into a table with a LONG data type.

>

> How can I do this with SQLLoader, what is the syntax of the control file

>

> Thanks
> Jonathan

>
> Received on Thu Dec 23 1999 - 08:11:00 CST