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.
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!
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.
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.
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?
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!
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.
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.
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!!!
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.
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!
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.
@@cesarl.c.847 thanks for the tip Cesar! Can you share our send me the link?
crisp and clear explanation...
thank u bro
was looking for instructions but all the info were confusing until I saw this video
Thanks, I am glad the content is helpful. Please do like the video and subscribe to our channel
Thank you very much, you helped me a lot!
Thank you, helped a lot!
MATE, Your awsome!
You are the best
Amazing .. very helpful
Thank you krishan
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.
@@cesarl.c.847 thanks a lot man....
Good presentation. Very helpful.
Thanks! Please do like the video and subscribe to our channel
keep up the good work. Thanks
Very nice explanation
Thanks Santosh, I am glad you enjoyed it :) Hope you have liked the video and subscribed to our channel!!!
Waiting for next video
Gotcha, good presentation 😊
Thanks Rushi!!!
Thank You sir
Nice explanation!!
Thanks bhoomi, I am glad you enjoyed it!!!
tq you so much sir
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?
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!
Maybe there are white space!!
Hi Kishan, Please make videos on RAC and performance tuning.
rac city rac rac city B
Ho kishan how to import database to csv to multiple target
Is it possible to load multiple tables in this method ? And how ?
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.
Very good explanation and thank you for all videos, but voice is very low. Can you please increase voice in next videos?
please share what is method of oracle sql loader into forms 6i
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?
Fiels doesn't define any action in database error solution?
Step by step written tutorial can be found here: numberblogs.blogspot.com/2020/04/oracle-sql-loader-hogyan-hasznaljuk-how.html
Where is tutorial 4 ? Can you post link please ?
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.
How to validate data in staging , can you please make a video
Hi Kishan,
Please make some videos on Oracle architecture for developers.
Thanks :)
How to do this load in non-empty tables?
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 ?
No, you need to create the table first to tell sql what kind of datatype your table will have for each column.
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
Sir, how to load data from one flat file to multiple tables
How to enable constraint(unique) in sql loader?
I want to bring data from two txt files, what do I do?
sqlldr is unrecognized command--getting this error
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.
How to insert data without deleting old data?
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!!!
Where is the next video??
I m getting error SQL*Loader - 128
I am also getting 500,509 errors please help me bro
Increase your volume man!!
Can i load 100,000 records using this??