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

[@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.

[@alexjoseph8433]

crisp and clear explanation...

[@PedroCarneiroJr1971]

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!

[@cesarl.c.847]

Hi Pedro, I recommend tool that 3 tutorials that you can search for like this: LoaderDataPlus tool for DBA, bulk load CSV. The tool automatically generates code for bulk upload using CSV files in Oracle with SQLLDR syntax. Initially the tool reads a flat file, detects its data types. Also exports to other DBMS: MariaDB-MySql, Ms Sqlserver, Postgresql.

[@PedroCarneiroJr1971]

@@cesarl.c.847 thanks for the tip Cesar! Can you share our send me the link?

[@kimted3272]

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

[@KishanMashru]

Thanks, I am glad the content is helpful. Please do like the video and subscribe to our channel

[@harshadashinde5775]

Thank you, helped a lot!

[@icovax]

Thank you very much, you helped me a lot!

[@balajiveeragandham9337]

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!

[@KishanMashru]

Maybe there are white space!!

[@jk_surman]

MATE, Your awsome!

[@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?

[@EllusionScience]

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

[@shivani581]

You are the best

[@pritammishra9850]

Thank you krishan

[@cesarl.c.847]

Hi Pritam, exists 3 tutorials can be found as: LoaderDataPlus tool for DBA, bulk upload CSV. The LoaderDataPlus tool helps to create code automatically to upload data (from CSV files or SQL sintax) to diferentes DBMS: Oracle, MariaDB-MySql, Ms Sqlserver, Postgres.

[@pritammishra9850]

@@cesarl.c.847 thanks a lot man....

[@thiruardura]

Good presentation. Very helpful.

[@KishanMashru]

Thanks! Please do like the video and subscribe to our channel

[@anjalishreya9890]

Ho kishan how to import database to csv to multiple target

[@rushimashru4630]

Gotcha, good presentation 😊

[@KishanMashru]

Thanks Rushi!!!

[@hemasingh1285]

keep up the good work. Thanks

[@ankitashirsat1054]

Amazing .. very helpful

[@estebanvarela2318]

How to do this load in non-empty tables?

[@VideoGraphy]

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

[@nasirhussain1121]

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

[@santhoshkumar8923]

Very nice explanation

[@KishanMashru]

Thanks Santosh, I am glad you enjoyed it :) Hope you have liked the video and subscribed to our channel!!!

[@trinathk7215]

Where is tutorial 4 ? Can you post link please ?

[@cesarl.c.847]

Hi Trinath, there is 3 tutorials can be found as: LoaderDataPlus tool for DBA, bulk upload CSV. The LoaderDataPlus tool helps to build code automatically to upload CSV files to diferentes DBMS: Oracle, MariaDB-MySql, Ms Sqlserver, Postgres.

[@hemasingh1285]

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

[@shaylinpadayachee7962]

rac city rac rac city B

[@bhoomimandalia1383]

Nice explanation!!

[@KishanMashru]

Thanks bhoomi, I am glad you enjoyed it!!!

[@venkatamaneswararaodudala2914]

Thank You sir

[@saradjaroud971]

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

[@mohankrishna3635]

tq you so much sir

[@mehrajshaikh918]

How to enable constraint(unique) in sql loader?

[@arzoogandhi1671]

sqlldr is unrecognized command--getting this error

[@cesarl.c.847]

Hi Arzoo, I recommend testing tool that 3 tutorials that you can search for like this: LoaderDataPlus tool for DBA, bulk load CSV. The tool create code automatically to upload data in Oracle with sqlldr commands. Initially the tool reads a flat file, detects its data types. Also exports to other DBMS: MariaDB-MySql, Sqlserver, Postgresql.

[@aditipatil3480]

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 ?

[@CesarSantosLopezYolo]

No, you need to create the table first to tell sql what kind of datatype your table will have for each column.

[@SatyendraSingh-ul5iq]

Sir, how to load data from one flat file to multiple tables

[@sudeshnap3703]

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

[@ramashis978]

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

[@AmitVerma-vb8hn]

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.

[@invisible111111]

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?

[@coolcap2023]

Waiting for next video

[@rahuldebnath8778]

I m getting error SQL*Loader - 128

[@ncrcottonbalesseeds118]

I am also getting 500,509 errors please help me bro

[@khalidhabibIT]

Where is the next video??

[@milindbidve446]

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

[@tapassahoo5197]

How to insert data without deleting old data?

[@KishanMashru]

INSERT : Table is empty load data APPEND : Table is not empty, append new records to existing one DELETE : Delete table's existing data, insert new data TRUNCATE : Truncate table's existing data, insert new data Hope this helps. Please like the video and subscribe to our channel!!!

[@ramramaraju2221]

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

[@faisal6827]

Can i load 100,000 records using this??

[@footballtv752]

Step by step written tutorial can be found here: numberblogs.blogspot.com/2020/04/oracle-sql-loader-hogyan-hasznaljuk-how.html

[@riyatiwari4767]

Increase your volume man!!