Home >> FAQs/Tutorials >> Oracle Tutorials
Oracle Tutorials - What Is SQL*Loader
(Continued from previous topic...)
What Is SQL*Loader?
SQL*Loader is a database tool that allows to load data from external files into database tables.
SQL*Loader is available as part of the free Oracle 10g Expression Edition. It has some interesting
- Can load data from multiple data files into multiple tables in one load session.
- Can specify character set of the data.
- Can generate sophisticated error reports.
- Can load data directly to Oracle datafiles, bypassing normal record inserting process.
(Continued on next topic...)
- What Is the Simplest Tool to Run Commands on Oracle Servers?
- What Is the Quickest Way to Export a Table to a Flat File?
- How To Export Data with a Field Delimiter?
- What Is SQL*Loader?
- What Is a SQL*Loader Control File?
- How To Load Data with SQL*Loader?
- What Is an External Table?
- How To Load Data through External Tables?
- What Are the Restrictions on External Table Columns?
- What Is a Directory Object?
- How To Define an External Table in a Text File?
- How To Run Queries on External Tables?
- How To Load Data from External Tables to Regular Tables?
- What Is the Data Pump Export Utility?
- What Is the Data Pump Import Utility?
- How To Invoke the Data Pump Export Utility?
- How To Invoke the Data Pump Import Utility?
- What Are Data Pump Export and Import Modes?
- How To Estimate Disk Space Needed for an Export Job?
- How To Do a Full Database Export?
- Where Is the Export Dump File Located?
- How To Export Your Own Schema?
- How To Export Several Tables Together?
- What Happens If the Imported Table Already Exists?
- How To Import One Table Back from a Dump File?
- What Are the Original Export and Import Utilities?
- How To Invoke Original Export/Import Utilities?