Oracle SQLLDR Import data

1. Background

   TXT text for 900W data, the contents of the file are in the fields "|" Delimited, use Nevicat import too slow

2. Solutions

   Using SQLLDR to import data,

   1) Setting up the configuration file Test.ctl

   [email protected] ~]$ cat Test.ctl
   Load data
   InFile ' Data.txt '
   into table CMCC
   Fields terminated by "|"
   (id,phone,service_id,time,cmcc_num,cmcc_s)

   Explanation: Data.txt The data file to import
   CMCC The table space to import
   Fields terminated by "|" with "|" Separated
   (id,phone,service_id,time,cmcc_num,cmcc_s) To import a table space field

3. 2) Import using Sqlldr: Sqlldr userid=smsanalysis/smsanalysis control=test.ctl Log=log

4. Postscript

   Problems encountered:

   1) The tablespace name is lowercase, test.ctl is lowercase, the table space is not present, and uppercase is changed
   2) field name is lowercase, prompt field name does not exist, change to uppercase
   3) The Time field in the table is set to Vachar

This article is from the "future Time and Space" blog, please be sure to keep this source http://sjitwant.blog.51cto.com/3661219/1847358

Oracle SQLLDR Import data