Edit Question - KnowledgeHub

Title Body

I'm pretty new to databases and programming. I'm not very good with the computer lingo so stick with me. I have a csv file that I'm trying to load into my Oracle database. It contains account information such as name, telephone number, service dates etc. I've installed Oracle 11g Release 2 . This is what I've done so far step by step.. 1) Ran SQL Loader I created a new table with the columns that I needed. For example create table Billing ( TAP_ID char(10), ACCT_NUM char(10), MR_ID char(10), HOUSE_NUM char(10), STREET char(30), NAME char(50) 2) It prompted me that the Table was created. Next I created a control file for the data in notepad which was located in the same directory as my Billing table and has a .ctl extension. GIS.csv is the file im getting the data from and is also in the same directory and named it Billing.ctl, which looked like so.. load data infile GIS.csv into table Billing fields terminated by ',' (TAP_ID, ACCT_NUM, MR_ID, HOUSE_NUM, STREET, NAME) 3) Run sqlldr from command line to use the control file sqlldr myusername/mypassword Billing.ctl This is where I am stuck. Ive seen video tutorials of exactly what I'm doing but I get this error: SQL*Loader-522: lfiopn failed for file (Billing.log) Any ideas on what I could be doing wrong here? Update I just moved the files into a separate directory and I suppose I got past the previous error. By the way yes Billing.ctl and GIS.csv are in the same directory. But now I have another error: 'SQL*Loader-350: Syntax error at line 1. Expecting keyword LOAD, found "SERV TAP ID". "SERV TAP ID","ACCT NUMBER","MTR ID","SERV HOUSE","SERV STREET","SERV ^' I dont understand why its coming up with that error. My billing.ctl has a load.

Tags (comma-separated) Cancel