Sql loader mistake

From: martial <mbourreau_at_hotmail.com>
Date: 30 Oct 2003 10:09:13 -0800
Message-ID: <f9355295.0310301009.2b1588f2@posting.google.com>

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:09:13 CST