Re: Error messages from using SQL*Loader

From: Suzie Gardiner <smg1_at_stir.ac.uk>
Date: 1997/02/20
Message-ID: <330C25B7.644B@stir.ac.uk>#1/1

You're missing some of the message files from ORACLE_HOME/rdbms/msg - probably because you're running a client installation (sqlldr message files are only installed with the database server). Copy them over from the same directory on the server installation

Suzie.

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
Received on Thu Feb 20 1997 - 00:00:00 CST