sqluldr2(sqluldr2)

Oracle的安装oracle的下载,安装请参考:https://www.cnblogs.com/hoobey/p/6010804.html值得一提的是:安装完成,首次启动Developer的时候,需要制定java.exe的路径。这个路径需要选择oracle安装目录下的路径。我的机器上,该路径为:F:\App\Administrator\product\11.2.0\dbhome_1\jdk\bin另外,若按照如上步骤安装连续报错:unable to find a JVM则是因为安装的Oracle 11g R2自带的SQL Develper是32bit的,但给它的JDK环境是64bit的,所以报错。只需要从Oracle官网下载Oracle SQL dEVELOPER x64,然后替换掉原安装目录(如F:\App\Administrator\product\11.2.0\dbhome_1)下的sqldeveloper文件夹,然后重新启动SQL Developer即可。

sqluldr2Sqluldr2是一款可以快速导出oracle数据库中的数据的小工具。

Oracle在PL/SQL Developer下,导出文件较慢,尤其在面对海量数据下载时,一款能够提速50%-75%数据下载速度的工具显得尤为重要。Sqluldr2是不错的选择。

下载链接:Sqluldr2。解压资源

在windows下,只需要在该地址下打开命令行窗口,直接执行对应的文件即可。

具体的数据格式和命令:

Usage: SQLULDR2 keyword=value [,keyword=value,…]

Valid Keywords:user = username/password@tnsnamesql = SQL file namequery = select statementfield = separator string between fieldsrecord = separator string between recordsrows = print progress for every given rows (default, 1000000)file = output file name(default: uldrdata.txt)log = log file name, prefix with + to append modefast = auto tuning the session level parameters(YES)text = output type (MYSQL, CSV, MYSQLINS, ORACLEINS, FORM, SEARCH).charset = character set name of the target database.ncharset= national character set name of the target database.parfile = read command option from parameter fileread = set DB_FILE_MULTIBLOCK_READ_COUNT at session levelsort = set SORT_AREA_SIZE at session level (UNIT:MB)hash = set HASH_AREA_SIZE at session level (UNIT:MB)array = array fetch sizehead = print row header(Yes|No)batch = save to new file for every rows batch (Yes/No)size = maximum output file piece size (UNIB:MB)serial = set _serial_direct_read to TRUE at session leveltrace = set event 10046 to given level at session leveltable = table name in the sqlldr control filecontrol = sqlldr control file and path.mode = sqlldr option, INSERT or APPEND or REPLACE or TRUNCATEbuffer = sqlldr READSIZE and BINDSIZE, default 16 (MB)long = maximum long field sizewidth = customized max column width (w1:w2:…)quote = optional quote stringdata = disable real data unload (NO, OFF)alter = alter session SQLs to be execute before unloadsafe = use large buffer to avoid ORA-24345 error (Yes|No)crypt = encrypted user information only (Yes|No)sedf/t = enable character translation functionnull = replace null with given valueescape = escape character for special charactersescf/t = escape from/to characters listformat = MYSQL: MySQL Insert SQLs, SQL: Insert SQLs.exec = the command to execute the SQLs.prehead = column name prefix for head line.rowpre = row prefix string for each line.rowsuf = row sufix string for each line.colsep = separator string between column name and value.presql = SQL or scripts to be executed before data unload.postsql = SQL or scripts to be executed after data unload.lob = extract lob values to single file (FILE).lobdir = subdirectory count to store lob files .split = table name for automatically parallelization.degree = parallelize data copy degree (2-128).

for field and record, you can use ‘0x’ to specify hex character code,\r=0x0d \n=0x0a |=0x7c ,=0x2c, \t=0x09, :=0x3a, #=0x23, “=0x22 ‘=0x27oracle数据导出工具sqluldr2

基本简介

  下载完sqluldr解压后,文件夹内容如下:  sqluldr2.exe 用于32位windows平台;  sqluldr2_linux32_10204.bin 适用于linux32位操作系统;  sqluldr2_linux64_10204.bin 适用于linux64位操作系统;  sqluldr264.exe 用于64位windows平台。

使用方法

  1、首先将sqluldr2.exe复制到执行目录下,即可开始使用  2、查看help 帮助

sqluldr2 官方下载

  3、执行数据导出命令  3.1、常规导出  sqluldr2 test/test@127.0.1.1/orcl query=”select * from temp_001” head=yes file=d:\tmp001.csv  说明:head=yes 表示输出表头

  3.2、使用sql参数  sqluldr2 test/test@127.0.1.1/orcl sql=test_sql.sql head=yes file=d:\tmp001.csv  test_sql的内容为:  select * from temp_001

  3.3、使用log参数  当集成sqluldr2在脚本中时,就希望屏蔽上不输出这些信息,但又希望这些信息能保留,这时可以用“LOG”选项来指定日志文件名。  sqluldr2 test/test@127.0.1.1/orcl sql=test_sql.sql head=yes file=d:\tmp001.csv log=+d:\tmp001.log

  3.4、使用 table 参数  当使用 table 参数时,在目录下会生成对应的ctl控制文件,如下语句会生成temp_001_sqlldr.ctl文件。  sqluldr2 test/test@127.0.1.1/orcl query=”select * from temp_001” table=temp_001 head=yes file=d:\tmp001.csv

原文链接:https://blog.csdn.net/b285795298/article/details/81872434

————————

For Oracle installation and Oracle download, please refer to: https://www.cnblogs.com/hoobey/p/6010804.html It is worth mentioning that when the installation is completed and developer is started for the first time, Java. Java. Com needs to be developed Exe path. This path needs to choose the path under the Oracle installation directory. On my machine, the path is: F: \ app \ administrator \ product \ 11.2.0 \ dbhome_ 1 \ JDK \ bin in addition, if you follow the above steps to install the continuous error: unable to find a JVM, it is because the installed SQL develper of Oracle 11g R2 is 32bit, but the JDK environment is 64bit, so the error is reported. Just download Oracle SQL devepeloper x64 from the official Oracle website, replace the sqldeveloper folder under the original installation directory (such as F: \ app \ administrator \ product \ 11.2.0 \ dbhome_1), and then restart SQL developer.

Sqluldr2sqluldr2 is a small tool that can quickly export data from Oracle database.

Oracle exports files slowly under PL / SQL developer. Especially in the face of massive data download, a tool that can speed up 50% – 75% data download speed is particularly important. Sqluldr2 is a good choice.

Download link: sqluldr2. Decompress resources

Under windows, you only need to open the command line window under this address and directly execute the corresponding file.

Specific data formats and commands:

Usage: SQLULDR2 keyword=value [,keyword=value,…]

Valid Keywords:user = username/password@tnsnamesql = SQL file namequery = select statementfield = separator string between fieldsrecord = separator string between recordsrows = print progress for every given rows (default, 1000000)file = output file name(default: uldrdata.txt)log = log file name, prefix with + to append modefast = auto tuning the session level parameters(YES)text = output type (MYSQL, CSV, MYSQLINS, ORACLEINS, FORM, SEARCH).charset = character set name of the target database.ncharset= national character set name of the target database.parfile = read command option from parameter fileread = set DB_FILE_MULTIBLOCK_READ_COUNT at session levelsort = set SORT_AREA_SIZE at session level (UNIT:MB)hash = set HASH_AREA_SIZE at session level (UNIT:MB)array = array fetch sizehead = print row header(Yes|No)batch = save to new file for every rows batch (Yes/No)size = maximum output file piece size (UNIB:MB)serial = set _serial_direct_read to TRUE at session leveltrace = set event 10046 to given level at session leveltable = table name in the sqlldr control filecontrol = sqlldr control file and path.mode = sqlldr option, INSERT or APPEND or REPLACE or TRUNCATEbuffer = sqlldr READSIZE and BINDSIZE, default 16 (MB)long = maximum long field sizewidth = customized max column width (w1:w2:…)quote = optional quote stringdata = disable real data unload (NO, OFF)alter = alter session SQLs to be execute before unloadsafe = use large buffer to avoid ORA-24345 error (Yes|No)crypt = encrypted user information only (Yes|No)sedf/t = enable character translation functionnull = replace null with given valueescape = escape character for special charactersescf/t = escape from/to characters listformat = MYSQL: MySQL Insert SQLs, SQL: Insert SQLs.exec = the command to execute the SQLs.prehead = column name prefix for head line.rowpre = row prefix string for each line.rowsuf = row sufix string for each line.colsep = separator string between column name and value.presql = SQL or scripts to be executed before data unload.postsql = SQL or scripts to be executed after data unload.lob = extract lob values to single file (FILE).lobdir = subdirectory count to store lob files .split = table name for automatically parallelization.degree = parallelize data copy degree (2-128).

for field and record, you can use ‘0x’ to specify hex character code,\r=0x0d \n=0x0a |=0x7c ,=0x2c, \t=0x09, :=0x3a, #=0x23, “=0x22 ‘=0x27oracle数据导出工具sqluldr2

Basic introduction

After downloading and decompressing sqluldr, the contents of the folder are as follows: sqluldr2 Exe is used for 32-bit windows platform;   sqluldr2_ linux32_ 10204.bin is applicable to Linux 32-bit operating system;   sqluldr2_ linux64_ 10204.bin is applicable to Linux 64 bit operating system;   sqluldr264. Exe is used for 64 bit windows platform.

usage method

1. First set sqluldr2 Copy exe to the execution directory to start using. 2. View help

Sqluldr2 official download

3. Execute the data export command 3.1. General export sqluldr2 test/ test@127.0.1.1 /orcl query=”select * from temp_ 001” head=yes file=d:\tmp001. CSV Description: head = yes indicates the output header

  3.2、使用sql参数  sqluldr2 test/test@127.0.1.1/orcl sql=test_sql.sql head=yes file=d:\tmp001.csv  test_sql的内容为:  select * from temp_001

3.3. Use the log parameter. When sqluldr2 is integrated into the script, you want the information not to be output on the screen, but you want the information to be retained. At this time, you can use the “log” option to specify the log file name.   sqluldr2 test/ test@127.0.1.1 /orcl sql=test_ sql. sql head=yes file=d:\tmp001. csv log=+d:\tmp001. log

3.4. Use the table parameter. When using the table parameter, the corresponding CTL control file will be generated in the directory. The following statement will generate temp_ 001_ sqlldr. CTL file.   sqluldr2 test/ test@127.0.1.1 /orcl query=”select * from temp_ 001” table=temp_ 001 head=yes file=d:\tmp001. csv

原文链接:https://blog.csdn.net/b285795298/article/details/81872434