Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error messages from using SQL*Loader
Motley Crue, Vaxxer wrote:
>
> When I tried to use the sqlload program using the below control file
>
> LOAD DATA
> INFILE 'test.dat'
> INSERT INTO TABLE TESTING
> (T1 POSITION(1:5) VARCHAR2(20),
> T2 POSITION(7:12) VARCHAR2(20))
>
> I got error messages in the log file given below
>
> SQL*Loader: Release 7.2.2.3.0 - Production on Sat Feb 15 12:26:12 1997
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
> Message 1 not found; No message file for product=RDBMS, facility=ULMessage 350 not found; No message file for product=RDBMS, facility=ULMessage 1002 not found; No message file for product=RDBMS, facility=UL(T1 POSITION(1:5) VARCHAR2(20),
> ^
> Message 4008 not found; No message file for product=RDBMS, facility=ULMessage 4009 not found; No message file for product=RDBMS, facility=ULMessage 4000 not found; No message file for product=RDBMS, facility=ULMessage 4001 not found; No message file for product=RDBMS, facility=UL
>
> Is there anything that I have missed out? TIA.
>
> --
> Choon Leong
You don't have ORACLE_HOME set and exported into your environment.
-- Rich Woods Technical Field Support Specialist, Oracle Corporation, USA The above statements and opinions are my own and do not necessarily represent those of Oracle Corporation.Received on Sun Feb 16 1997 - 00:00:00 CST