The UNIX and Linux Forums  


Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
.
google unix.com




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #3 (permalink)  
Old 02-11-2009
pareshan pareshan is offline
Registered User
  
 

Join Date: Dec 2008
Posts: 24
Hi Jim, first of all thanks
I have done something like this

this is controlfile
control_file

LOAD DATA
INFILE '/home/gc1488/FST/input'
INTO TABLE unix_servers
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(SERVER_ID NUMBER(6),
SERVER_NAME VARCHAR2(20),
MARKET CHAR(3),
SERVER_TYPE VARCHAR2(15),
PROD_IND CHAR(1),
OWNER VARCHAR2(20))

I already have input file in that location. One thing the table im going to use should already exist or doesnt matter because I have to insert into the table which is already there. but in this example im trying to use the table which doesnt exist because I think sqlldr will create table if doesnt exists right?

But I got one error, it says

SQL*Loader-350: Syntax error at line 5.
Expecting "," or ")", found "NUMBER".
(SERVER_ID NUMBER(6),
^

Also could you tell me how can i use the existing table here.

thank you very much