Oracle SQL Loader - How to load data from file(.csv, .dat, .txt) into table - Tutorial - 3

This video is the third tutorial on Oracle SQL*Loader tutorial series created by Kishan Mashru.

Oracle SQL Loader utility is used to load data from flat files like .csv files, .dat files, .txt files into Oracle database tables.
In this video tutorial, we demonstrated how to load data from excel to oracle using sql loader

We showed the SQL Loader control file example and loaded data from the .csv file into the database table.

Check out the advantages of using TRUNCATE over a DELETE from the following video:

#KishanMashru #Oracle #SqlLoader #SqlLoaderExample #LoadCSV #LoadExcel #SQLandPLSQL #OracleSqlLoader
#ETL #database

[marcinbadtke]

Thanks for your video :-)

Worth to mention that - to speed up loading process - you can load to many table partitions in parallel.
There are also PARALLEL and MULTITHREADING options for SQL*Loader itself.

[PedroCarneiroJr]

Hey, Kishan! I'm waiting for the next video to get more details about the SQLLDR syntax/usage. No doubt you're helping me automate things down here! Thanks a lot!

[icovax]

Thank you very much, you helped me a lot!

[kimted]

thank u bro
was looking for instructions but all the info were confusing until I saw this video

[invisible]

Thank you for the great tutorial. Am waiting for your next tutorial. Is it possible to code this on Apex so it is done with a click of a button?

[agtaxservice]

thanks Kishan, this is very helpful video but i did everything like yours and sql loader in my pc give me errors, "it says unable to open file, file not found" how could i over come these errors?

[AmitVerma-vbhn]

A very simple and impressive way to teach Thanks.Can you please ping here the next video link.. I am not able to find it out.

[ramramaraju]

Hi Kishan,
Please make some videos on Oracle architecture for developers.
Thanks :)

[milindbidve]

Very good explanation and thank you for all videos, but voice is very low. Can you please increase voice in next videos?

[saradjaroud]

I want to bring data from two txt files, what do I do?

[mehrajshaikh]

How to enable constraint(unique) in sql loader?

[VideoGraphy]

Is it possible to load multiple tables in this method ? And how ?

[aditipatil]

Hello,
If I don't have a table in my DB then is it possible to load data from a (.csv) file using the column head as columns for the table ?

[ramashis]

How to validate data in staging, can you please make a video

[hemasingh]

Hi Kishan, Please make videos on RAC and performance tuning.

[sudeshnap]

Hi kishan while iam loading the data from flatfile to tables iam getteing error . that error is check the log files, please can u clarify me

[estebanvarela]

How to do this load in non-empty tables?

[balajiveeragandham]

Hi,
I am trying to load a data file into a database table using SQL loader. I received the data in an Excel spreadsheet but I saved it as a comma delimited file.
When I run the SQL Loader command no records are loaded - looking at the log file I get the following error:
Rejected - Error on table ABC, column ABC_C.
Field in data file exceeds maximum length
I don't understand why this is happening as the maximum length of the ABC_C field for any record I've attempted to load so far is 400 characters long and the field definition in the database table is VARCHAR2(4000).
Please help!

[EllusionScience]

Fiels doesn't define any action in database error solution?

[nasirhussain]

please share what is method of oracle sql loader into forms 6i