Humberto, with the limited information you have provided, I suspect the
problem is at least partially your database character set. If you
defined your database with a 32-bit unicode character set, then each
character requires 4 bytes (32 bits) of space. This would mean that the
700 character byte string is stored as 2800 bytes.
This won't explain why the data will not fit in 4000 bytes, but you
should find out what character set your database uses to help understand
your space requirements.
Next I would look in your load data and make sure the data is the length
you expect. You might try using that data directly in a SQL insert
command, i.e.
INSERT INTO supp_serasa (col1) values('<<the text from your load data
here>>');
Don't enter the << and >> from the command above, and you might have to
adjust the insert for non-null columns.
This will confirm whether the data itself is the problem or something
else is causing trouble.
On Thu, 2005-10-27 at 16:04 -0200, Humberto Alexandre V. Lima wrote:
> Gurus,
> I changes my aproach, i have created a id for each line in a text file and
> still trying to load with SQL*Load
> But now the load gives me the error:
> Record 116: Rejected - Error on table SUPP_SERASA, column COL1.
> Field in data file exceeds maximum length
> And it aborts the load!
>
> My string is 700 chars long and the COL1 column is Varchar2(4000).
>
> How can it be possible? Isn't it enough space in 4000 bytes for a string 700
> bytes long???
>
> Does anyone have any idea about what is going on?
>
>
> Tks and have a nice day
> Humberto
>
> -----Original Message-----
> From: Cliff Palmer
> [mailto:oracledba-ezmlmshield-x62922111.[Email address protected]
> Sent: quinta-feira, 27 de outubro de 2005 14:25
> To: LazyDBA Discussion
> Subject: Re: SQL*Load
>
> Humberto, you need to look further into the SQL*Loader documentation.
> In particular you need to find how to describe the contents of the text
> file to SQL*Loader so it knows how to find the values for the columns in
> supp_help.
> Once you have done that you can look into adding a sequential value.
> HTH
> Cliff
> On Thu, 2005-10-27 at 13:02 -0200, Humberto Alexandre V. Lima wrote:
> > Hi gurus,
> >
> >
> >
> > I'm trying to load data into oracle with Sql*loader, everything went fine
> > but I need a PK to regulate the order of the lines loaded, and I don't
> know
> > how to add a PK during a simple load, like this:
> >
> > /* This is my config.cfg */
> >
> > load data
> >
> > infile 'Acesso.txt'
> >
> > into table supp_help( col1 char(1500) )
> >
> > /* End of config.cfg */
> >
> >
> >
> > inside that table:
> >
> > CREATE TABLE supp_help(
> > num int not null,
> > col1 CHAR(1500) NULL,
> > constraint supp_help_pk primary key(num)) tablespace teste_data
> >
> >
> > It complains about the insert of null values inside the num field.
> >
> > Don't know how to add the PK field during the load.
> >
> >
> >
> > Can someone give me a clue about how to solve that?
> >
> > If you send me a good link to read about SQL*loader is enough.
> >
> >
> >
> > Tks in advice.
> >
> >
> >
> > Humberto
> >
> >
> >
> >
> >
> > --------
> > website: http://www.LazyDBA.com
> > Please don't reply to RTFM questions
> > Oracle documentation is here: http://tahiti.oracle.com
> > To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> > To subscribe: see http://www.lazydba.com
> > By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page