Oracle SQL Loader | Import CSV into Oracle database

Published: 20 October 2019
on channel: DBA Genesis
31,443
314

SQL*Loader is a bulk loader utility used for moving #data from external files into the #Oracle #database. Its #syntax is similar to that of the #DB2 load utility, but comes with more options. #SQL*Loader supports various load formats, selective loading, and multi-table loads.

00:00 Oracle SQL*Loader
01:13 SQL*Loader Components
01:18 Control File
01:48 Input Files or INFILE
02:07 Log File
02:17 Bad File
02:35 Discard File
03:39 Oracle SQL*Loader-Lab
03:48 Create table for rows import from CSV files
04:35 Create a sample CSV file at OS level
07:27 Create SQL loader control file
11:17 Invoke the SQL loader utility

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis  


Watch video Oracle SQL Loader | Import CSV into Oracle database online without registration, duration hours minute second in high quality. This video was added by user DBA Genesis 20 October 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 31,443 once and liked it 314 people.