Oracle Export Import Utility | Oracle 11g Administration 

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: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis

Наука