Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQLLDR ERROR
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