Sql Loader

[syncdba]

Hi,
I have a table with 3(ID,TYPE,DESCRIPTION) fields & I only want to load DESCRIPTION column into mapping_delivery_type table..I'm getting error at Line 3
Expecting Keyword INTO, Found'Description'.

LOAD DATA
INFILE 'boniva.delivery_types@SABA_TO_BONIVA'
Description
APPEND
INTO TABLE mapping_delivery_types
(
Source_Delivery_Type "LTRIM(RTRIMSource_Delivery_Type))"
)
Can somebdy please correct the file

 

[djbjr]

Umm isnt the description the name of your fields?

Shouldnt your script look like this?

LOAD DATA
INFILE 'boniva.delivery_types@SABA_TO_BONIVA'
APPEND
INTO TABLE mapping_delivery_types
(
Description "LTRIM(RTRIMSource_Delivery_Type))"
)

Try it and let me know if it works.

~dj

 

[syncdba]

Description is the field from 'boniva.delivery_types@SABA_TO_BONIVA' & I want to load values of DEscription field into source_delivery_types (Mapping_delivery_type table). Giving error description is not known field.
Thanks for ur reply. What Should I do know.

 

[djbjr]

So 'boniva.delivery_types@SABA_TO_BONIVA' is another table?

I have never SQL Loader with another table as a source. I only use SQL Loader for loading flat files.

Is 'boniva.delivery_types@SABA_TO_BONIVA' a database link?

If so, why can you just use an insert statement?