How to Create a Control In Notepad
820058Nov 30 2010 — edited Nov 30 2010Hello:
I am need help creating a control file. I have never done this before. I have to load the following script into notepad:
load data
infile 'names.txt'
badfile 'names.bad'
truncate
into table names
fields terminated by ','
trailing nullcols
(first,last)
I then went to Command Prompt to begin the SQL Loader command and recieved the following message.
SQL*Loader-500: Unable to open file (names.ctl)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the specified file.
I really need help on this. I am very new to Oracle.
** I created the file in Notepad and saved the file as names.ctl (all files). *****