Load Data from .csv file problems
295545Nov 20 2006 — edited Nov 20 2006Hi There
I am usimg sql loader first time and run on some problems
I am trying to upload data from .csv file into some temporary table. First row in that .csv file are column names.
Every time i get the same error : ERROR at line 1:
ORA-00900: invalid SQL statement - for which i tripple checked all table columns
Here is my command :
LOAD DATA INFILE 'c:\Proj\Leads.csv'
INTO TABLE g_lead
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(CONTACT_NAME
,COMPANY_NAME
,ADDRESS
,CITY
,PROVINCE_CODE
,POSTAL_CODE
,PHONE
,FIRST_NAME_LAST_NAME
,FAX_NUMBER
,LOC_SALES_VOLUME_CODE1
,ACTUAL_CORPORATE_EMP_SIZE
,SECONDARY_ADDRESS
,SECONDARY_CITY
,SECONDARY_PROVINCE_CODE
,SECONDARY_POSTAL_CODE
,LOOKUPSIC
,LOOKUPNAICS
,LOOKUPDUNS
,LOOKUPNAICS3
,LOOKUPNAICS3DESCRIPTION
,LOOKUPNAICSDESCRIPTION
)
Can someone help me what is the problem here . Table columns are correct. I also tried to remove from .csv file first row , which is the column names.