Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQLLDR ERROR

SQLLDR ERROR

From: martial <mbourreau_at_hotmail.com>
Date: 26 Dec 2003 02:57:17 -0800
Message-ID: <f9355295.0312260257.45b3e181@posting.google.com>


hello,

I made a sql loading program wich load a simple text file into one table.
I'm on ORACLE 8.1.7.4 in UNIX AIX.

The problem is when i truncate my table and i run this programs i get the following mistake :
Record 1: Rejected - Error on table ARAMIS.WK_RGP_PRJ. ORA-01115: IO error reading block from file 2 (block # 994) 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

If i insert one value thanks to a SQL script : INSERT INTO ...
and then i run the sqlldr script, this works perfectly.

What the problem is about ? what can i make to correct this ?

Thanks for your answer, this can be really helpfull.

martial. Received on Fri Dec 26 2003 - 04:57:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US