| SQL*LDR [message #427488] |
Thu, 22 October 2009 20:35  |
sandeep.blacktrack
Messages: 1
Registered: October 2009
|
Junior Member |
|
|
My CTL file follows
-- ORACLE Ver 8, SQL*load script to load table "emp204"
-- WJM, Oct 09;
-- Rev 1 Oct 07 File references: quote a path+filename if not a local .dat file
LOAD DATA
INFILE *
INTO TABLE emp204 WHEN tab = tab1
(E_PK position(01:01) char,
DNO position(02:02) char
)
INTO TABLE dept204 WHEN tab = tab2
(
D_PK position(01:01) char,
MGRSSN position(02:02) char
)
INTO TABLE emp_j204 WHEN tab = tab3
(
E_PK position(01:01) char,
JOB_PK position(02:02) char
)
INTO TABLE emp_j_t204 WHEN tab = tab4
(
E_PK position(01:01) char,
JOB_PK position(02:02) char,
TASK_PK position(03:17) varchar
)
BEGINDATA
tab1|/xx/abd/fff/kkk1.dat
tab2|/xx/abd/fff/kkk2.dat
tab3|/xx/abd/fff/kkk3.dat
tab4|/xx/abd/fff/kkk.dat
When i try to load the data i get this ERROR
SQL*Loader: Release 10.2.0.1.0 - Production on Thu Oct 22 18:14:08 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL*Loader-350: Syntax error at line 7.
Expecting ")", ":" or "-", found "(".
(
Can anyone please help me 
|
|
|
|
|
|
| Re: SQL*LDR [message #427625 is a reply to message #427488] |
Fri, 23 October 2009 10:50  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
sandeep.blacktrack wrote on Fri, 23 October 2009 03:35
INTO TABLE emp204 WHEN tab = tab1
This kind of lines are suspicions; according to documentation (search for "Choosing Which Records to Load" section), a character string should be enclosed into single quotes (i.e. ... WHEN tab = 'tab1').
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
