Re: Sql loader mistake

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 Thu Oct 30 2003 - 12:57:32 CST