SQL*Loader-287: No control file name specified.Įxecute the sqlldr command to upload these new record to the empty table by specifying both uid/pwd and the control file location as shown below. As you see below, both of these will prompt you for control file location, as it was not given in the command line. You can pass the userid and password to the sqlldr command using any one of the following format. ORA-04043: object EMPLOYEE does not exist SQL*Loader-941: Error during describe of table EMPLOYEE Note: If you don’t have the table created, you’ll get the following error message: Note: If you have the values inside the data file enclosed with double quote, use this in your control file: fields terminated by “,” optionally enclosed by ‘”‘ Next create the control file that explains what needs to be upload and where. ( id, name, dept, salary ) – Lists the name of the column names in the table into which the data should be uploadedįirst, create the employee table as shown below. Into table – Indicates the table name where this data should be insertedįields terminated by – Indicates the delimiter that is used in the input file to separate the fields Infile – Indicates the location of the input data file The above control file indicates the following: This tells sqlldr the location of the input file, the format of the input file, and other optional meta data information required by the sqlldr to upload the data into oracle tables. This contains the instructions to the sqlldr utility. For some of the examples mentioned below, we’ll use the following employee.txt file to upload the data to the employee table. Each and every records needs to be in a separate line, and the column values should be delimited by some common delimiter character. This is the input text file that contains the data that needs to be loaded into an oracle table. This article provides 10 practical examples on how to upload data from a flat file to Oracle tables. If you are using Oracle database, at some point you might have to deal with uploading data to the tables from a text file. Why reinvent the wheel when some already did exactly what I want? The below tutorial is an exact copy from the link and Ramesh Natarajan is the Author. This has everything that I wanted to put on my blog.

Sqlldr control file example