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 -> Re: Error messages from using SQL*Loader

Re: Error messages from using SQL*Loader

From: Rich Woods <rawoods_at_concentric.net>
Date: 1997/02/16
Message-ID: <3307CB16.2770@concentric.net>#1/1

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

Original text of this message

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