Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to export sqluldr2", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to export sqluldr2" this article.

Brief introduction:

Sqluldr2: one of the professional tools for exporting large amounts of data, its efficiency is 70% faster than that of ordinary export. (Sqlldr: one of the professional tools for import, please note the difference between the two tools.) When in use, it is best to write to disk with fast speed, good network and fast network speed.

List of tools:

Use different export tools for different platforms:

Windows: sqluldr2.exe

Linux (32-bit): sqluldr2_linux32_10204.bin

Linux (64 bit): sqluldr2_linux64_10204.bin

Instructions for use (Windows platform):

To use sqluldr2:

1. Open the run à cmd to enter the current directory of sqluldr2.exe

two。 Parameter introduction

User= user / password @ tns

Query= "query statement"

Path to File= export

When Head= outputs information, yes means to want the header, and no means not to.

Note: to see more parameters, please enter sqluldr2 help=yes

Code example 1:

Sqluldr2.exe USER= user / password @ tnsQUERY= "select / * + parallel (8) * / * from cs_XXX dt,cfg_XXX devdim105 wheredt.starttime > = to_date ('2012-06-27 00 parallel 00mm hh34:mi:ss' dd hh34:mi:ss') and dt.starttime

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.