Re: Sql loader mistake

Thanks kenneth for your answer.
After many tests and a simple test of insert with sql+ that the error concerne a foreign key i defined on that table.

It's really stupid to lose his time for so few things !!!!!

martial.

Kenneth Koenraadt wrote in message news:<3fa15e88.2108892_at_news.inet.tele.dk>...
> Most likely you have reached the "ulimit" for the O/S user owning the
> datafile '/apps/oracledata/ARMT/data0001/ARMT_DATA01.dbf' (bet that
> user is 'oracle'.
>
> Raise the ulimit for the oracle user, possibly to "unlimited".
>
> - Kenneth Koenraadt
>
> On 30 Oct 2003 10:09:13 -0800, mbourreau_at_hotmail.com (martial) wrote:
>
> >Hello,
> >
> >I'm trying to use sql loader on UNIX AIX with an oracle version
> >8.1.7.4.
> >
> >My script file is :
> >
> >LOAD DATA
> >INFILE 'essai.txt'
> >BADFILE 'head.bad'
> >DISCARDFILE 'head.dsc'
> >INTO TABLE ARAMIS.IND_WU
> >FIELDS TERMINATED BY ','
> >TRAILING NULLCOLS
> >( IND_CDE_WU ,
> > CDE_WU char ,
> > LIB_WU char ,
> > CUBE ,
> > ATT_CON
> >)
> >
> >
> >I get the following mistake :
> >
> >Record 1: Rejected - Error on table ARAMIS.IND_WU.
> >ORA-01115: IO error reading block from file 2 (block # 1484)
> >ORA-01110: data file 2:
> >'/apps/oracledata/ARMT/data0001/ARMT_DATA01.dbf'
> >ORA-27092: skgfofi: size of file exceeds file size limit of the
> >process
> >Additional information: 131071
> >Additional information: 256001
> >
> >
> >I don't think that ctl script in incorrect because very simple and my
> >import file only have one record with thoses columns.
> >If anyone knows where this problem is about (if it's on Oracle or on
> >my script) please to help me.
> >
> >thanks,
> >
> >martial.
Received on Mon Nov 03 2003 - 06:47:08 CST