Home » RDBMS Server » Server Utilities » loading data into multiple tables , help
loading data into multiple tables , help [message #228134] Sun, 01 April 2007 06:02 Go to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
HI
i am trying to load data from a flat csv file into two different tables using when clause but it gives me the error

CONTROL FILE:
load data
infile 'e:\softwares\inr_rates.csv'
insert into table scott.bti
when(rupeeval < 0)
fields terminated by ','
(country_name,rupeeval,inind)

TARGET TABLE:
Name Null? Type
----------------------------------------- -------- ----------------------------
COUNTRY_NAME VARCHAR2(25)
RUPEEVAL NUMBER
ININD NUMBER

ERROR:

E:\>SQLLDR SCOTT/TIGER CONTROL=AA.CTL

SQL*Loader: Release 9.0.1.1.1 - Production on Sun Apr 1 16:31:00 2007

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL*Loader-350: Syntax error at line 4.
Illegal combination of non-alphanumeric characters
when(rupeeval < 0)
^
I WANTED TO INSERT THOSE ROWS ONLY WHOSE RUPEEVAL IS less THAN ZERO.

please help
regards
abood

[Updated on: Sun, 01 April 2007 06:03]

Report message to a moderator

Re: loading data into multiple tables , help [message #228138 is a reply to message #228134] Sun, 01 April 2007 06:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Always search before posting and save your time!
Just few threads below, the same topic is been discussed.
http://www.orafaq.com/forum/t/79065/42800/
Re: loading data into multiple tables , help [message #228143 is a reply to message #228138] Sun, 01 April 2007 08:53 Go to previous message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
hi
Thanks.
Previous Topic: sql loader using function returing a varray
Next Topic: How can i Do.
Goto Forum:
  


Current Time: Fri Dec 02 12:26:13 CST 2016

Total time taken to generate the page: 0.06004 seconds