| RE:nested table and sql*loader [message #122971] |
Thu, 09 June 2005 07:11 |
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
|
Senior Member |
|
|
hi,
i have a doubt regarding loading data from a cvs file to a nested table. below is the syntax to load data.
script to load data.
load data
infile *
append into
table state_tm_planner
fields terminated by ','
(region,state,state_tm_sp_nt(state_tm_sp_ty(territory,tm_name,tm_id,tm_tel,tp_name,tp_id,tp_tel)))
begindata
err message:
sql*loader-350:syntax error at line 6.
expecting "," or ")",found "(".
(region,state,state_tm_sp_nt(state_tm_sp_ty(territory,tm_name,tm_id<tm
any suggestions or some other way of getting the work done.
regards,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
