What is SQL*Loader and what is it used for?[edit]
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.
SQL*Loader (sqlldr) is the utility to use for high performance data loads. The data can be loaded from any text file and inserted into the database.
How does one use the SQL*Loader utility?[edit]
One can load data into an Oracle database by using the sqlldr (sqlload on some platforms) utility. Invoke the utility without arguments to get a list of available parameters. Look at the following example:
sqlldr username@server/password control=loader.ctl sqlldr username/password@server control=loader.ctl
This sample control file (loader.ctl) will load an external data file containing delimited data:
load data infile 'c:\data\mydata.csv' into table emp fields terminated by "," optionally enclosed by '"' ( empno, empname, sal, deptno )
The mydata.csv file may look like this:
10001,"Scott Tiger", 1000, 40 10002,"Frank Naude", 500, 20
Optionally, you can work with tabulation delimited files by using one of the following syntaxes:
fields terminated by "\t" fields terminated by X'09'
Additionally, if your file was in Unicode, you could make the following addition.
load data CHARACTERSET UTF16 infile 'c:\data\mydata.csv' into table emp fields terminated by "," optionally enclosed by '"' ( empno, empname, sal, deptno )
Another Sample control file with in-line data formatted as fix length records. The trick is to specify "*" as the name of the data file, and use BEGINDATA to start the data section in the control file:
load data infile * replace into table departments ( dept position (02:05) char(4), deptname position (08:27) char(20) ) begindata COSC COMPUTER SCIENCE ENGL ENGLISH LITERATURE MATH MATHEMATICS POLY POLITICAL SCIENCE 这样我们就可以把数据量特别大的csv导入到oracle中了。
相关推荐
oracle sql loader全攻略,帮助你理解和用好oracle sql loader工具
oracle sql loader的简单使用实例
oracle sql loader 用法详解
SQL*Loader-Oracle高速数据装入最佳工具软件.pdf
oracle -sqlloader使用方法,适合初学者
与.bat脚本配合使用 load data infile 'C:\Users\yilin\Desktop\abc.txt' append into table FJH_TMP fields terminated by " " (A)
NULL 博文链接:https://jxdwuao.iteye.com/blog/1704642
利用sqlloader将 excel 数据导出到 oracle 数据库中
本教程只捡最有用的部分讲解...首先需要明确的,那就是SQLLoader依赖于Oracle客户端,如果一个应用服务器上没有安装Oracle客户端(10G以后版本只需要安装有服务器端或者客户端即可),那么是无法应用SQLLoader特性的。
NULL 博文链接:https://huangjiateng.iteye.com/blog/2003207
DataPump 、SqlLoader两种方式备份还原oracle数据库
sql * loader是oracle的数据加载工具,通常用来将操作系统迁移到oracle数据库中,
涂抹ORACLE-第5章-SQLLoader 加载数据之一千零一十一个怎么办
SQL*LOADER是oracle的数据加载工具,在NT下sql*loader的命令为SQLLDR,在UNIX下一般为SQLLDR/SQLLOAD。通常用来将操作系统文件迁移到oracle数据库中。它是大型数据仓库选择使用的加载方法,因为它提供了最快速的途径...
oracle sqlloader 使用指南 数据装载
Oracle数据库使用SQL_Loader导入外部数据的方法详解,详细讲解 sqlldr的使用
sqlloader详解
SQLLoader.doc BI study plan—draft.doc Common+Warehouse+Metamodel(CWM)Specification.pdf Informatic PowerCenter7基础培训.pdf Informatica Install.doc Informatica training.ppt informatica介绍2010-5-25....
SQL*LOADER是ORACLE的数据加载工具,通常用来将操作系统文件迁移到ORACLE数据库中。SQL*LOADER是大型数据仓库选择使用的加载方法