SQL * Loader (SQLLDR) is an Oracle high-speed Batch Data Loading tool. It is a very useful tool for loading data to Oralce databases in multiple flat file formats.
SQL * Loader (SQLLDR) is an Oracle high-speed Batch Data Loading tool. It is a very useful tool for loading data to Oralce databases in multiple flat file f
"," C2 "," C3 ",) VALUES (Null,null,null,null) /*+ Sys_dl_cursor */is the way SQL loader, which means that bulkcopy needs to be used with caution because he will invalidate the index of the table. An exclusive lock on the table is executed before the SQL loader is executed: Lock table "LC0079999". " Jkl_test "in EXCLU
Oracle SQL loader uses quick Oracle SQL LOADER, which is an Oracle Data Loading tool used to load data from fixed text files to Oracle databases. It provides the fastest Loading Method (direct/parallel) and is a perfect tool for fast loading of big data. It is widely used in data warehouse applications. Let's take a lo
Tags: sqlloader Import DatabaseBefore my blog once wrote how to use Toad this tool from Excel or CSV file to import data into the database. In fact, Oracle itself provides such a tool, called Sql*loader. This tool is less straightforward and error-prone, but it is ideal for importing large amounts of text. Execution is very efficient, claiming that an hour can be imported into the G (heard).Here is a simple
Tags: keyword insert database tiger recordSql*loader usage:Sqlldr Keyword=value [, Keyword=value, ...]Sql*loader the processing of records through control files, example command line Sqlldr Scott/tiger control=case.ctl (not database sql>)Case.ctl content is as follows:Load dataInFile * # #使用 * Indicates the loaded data
Tags: keyword insert database tiger recordSql*loader usage:Sqlldr Keyword=value [, Keyword=value, ...]Sql*loader the processing of records through control files, example command line Sqlldr Scott/tiger control=case.ctl (not database sql>)Case.ctl content is as follows:Load dataInFile * # #使用 * Indicates the loaded data
Objective: To insert data in an excel file into an oracle database
Steps:
1. Open MicroSoft Excel 2000
2. File (F) → new (N) → workbook →
3. After the data is input, the storage disk is test.xls,
4. File (F) → save as (A) →
The storage type is: delimiter, the name is text.txt, and saved to C:
5. Create a table structure first:
Connect to SQL * Plus and Log On As A system/manager User,
SQL> conn sys
Objective: To insert data in an excel file into an oracle database
Steps:
1. Open MicroSoft Excel 2000
2. File (F) → new (N) → workbook →
3. After the data is input, the storage disk is test.xls,
4. File (F) → save as (A) →
The storage type is: delimiter, the name is text.txt, and saved to C :\
5. Create a table structure first:
Connect to SQL * Plus and Log On As A system/manager User,
SQL> conn system/man
This article is worth noting. I will try again tomorrow. Today is so tired!
How to use SQL * loader?
Dragon2> sqlldr userid = C/C control = lc2.ctl log = lc2.log bad = lc2.bad
SQL * Loader: Release 9.2.0.1.0-production on Wed Jun 4 18:03:53 2003
Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.
Commit
Transfer from http://www.jiejingwang.com 2002-10-24 shortcut Network========================================================== =System Environment:1. Operating System: Windows 2000 Server, 128 MB of machine memory2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition3. installation path: C: OracleSteps:1. Open Microsoft Excel 20002. File (f) → new (n) → workbook →3. input the following data, and the storage disk is test.xls,
4. File (f) → save as (a) →The storage type is: delimiter, the n
Environment: Oracle 10g 10.2
There is a text data in the following format:
HLR_CODE HLR_TYPE REGION_CODE AREA_CODE PROV_CODE BUREAU_CODE VALID_DATE EXPIRE_DATE MODIFY_DATE1 1302309 1 565 565 551 Z00 2000-1-1 2020-12-31 23:59:59 20:22:562 1302310 1 210 21 210 Z00 2000-1-1 2020-12-31 23:59:59 20:22:563 1302311 1 210 21 210 Z00 2000-1-1 2020-12-31 23:59:59 20:22:564 1302312 1 210 21 210 Z00 2000-1-1 2020-12-31 23:59:59 20:22:56
You need to import the data to a table:
Create table BS_HLR_INFO(HLR_CO
How to import data to oracle database using SQL * loader, loaderoracle
When you need to import massive data into the database, the efficiency of using the graphical interface tool is very low. Here we will briefly introduce how to import the database using SQL * loader.
First, observe the table structure. If the cu
Tags: OSI file name pen field LLD Bad text character dia usage of SQL Loader 1. log in to the database server and switch to the Oracle user. 2, execution command:sqlldr system/t_dpwds8 control=/opt/huawei/sqlldr/imp.ctl skip=1 Description:sqlldr is followed by the user name and password of the database user, control is followed by the address of the file , and Skip indicates how many rows were skipped befo
oracle sqlloader used to load the contents of the data file on the operating system into the oracle database . to use sqlloader, , inside tell sqlloader started sqlloader After the policy of loading data . Create a new studentdataload.ctl file , write Load data infile ' studentdata.txt ' into table studentinfo fields terminated by ' | ' (num,name,classnum,tel,address) and then started in the console Span style= "Font-family:times New Roman; Background-color:
Prerequisite, you need to install the Oracle client locallyControl file Cms.ctlLoad dataCHARACTERSET UTF8InFile ' Oracle.txt 'APPEND into TABLE JRFields terminated by ' | '(Bukrs,Lonno,Waers,Bldat,Budat,SHKZG,Dlcod,Hkont,FPGRP,Fpnam,LONPR,WRBTR,Ecnma,Dlnam,EVTCD,SEVTC,SEVTD,CITYC,City,LONTP,Payer,Region)CD D:/XLS2Sqlldr Userid=oaadmin/[email protected] Control=cms.ctlExitOne: Features of SQL loaderOracle itself has a number of tools that can be used f
When using datastage for development, the following error occurs:
SQL * loader-951: Error calling once/load Initialization
ORA-00604: Error occured at recursive SQL Level 1
ORA-00054: Resource busy and acquire with Nowait specified
Move out of Google:
It may be because the index in the table is in the unusable state --> leading to the index unusable: duplica
SQLLDR ToolsThe Sql*loader client tool is Sqlldr, enter SQLLDR under the command line of the operating system, and then do not take any parameters, and the Help information shown below (a simple description of all command-line arguments and their default values), so you do not need to memorize the following parameters, and when you forget them, You can quickly query this way.[Plain]View PlainCopyprint?
OEM:Http: // full computer name: 5500/em/
Sys/System managerScott tiger1. Forget the logon password of a user except SYS and SYSTEM.Log On As a sys (or SYSTEM) user.Conn sys/PASS_WORD as sysdba;Use the following statement to modify the user password.Alter user user_name identified by newpass;Table integrity:1. entity integrity-UK ensures the uniqueness of data from the database perspective (unique constraint)2. Domain integrity-PK3. Integrity-FKConstraints:Primary key constraint: PK
Foreign key
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.