用sqlldr从mysql导出一个表的数据到oracle_MySql_学习笔记★闵涛★计算机学习电脑编程软硬件技巧


	转至繁体中文版	\| 网站首页 \| 图文教程 \| 资源下载 \| 站长博客 \| 图片素材 \| 武汉seo \| 武汉网站优化 \|

用sqlldr从mysql导出一个表的数据到oracle

作者：闵涛文章来源：闵涛的学习笔记点击数：3288 更新时间：2009/4/22 20:48:42

SQL Loader
    B03_12                          CHAR (255)
      Terminated by "09"
      Trim whitespace same as SQL Loader
    CATE_ITEM_CODE                  CHAR (255)
      Terminated by "09"
      Trim whitespace same as SQL Loader
    PRODUCT_NAME                    CHAR (255)
      Terminated by "09"
      Trim whitespace same as SQL Loader
    PRODUCT_UNIT                    CHAR (255)
      Terminated by "09"
      Trim whitespace same as SQL Loader
KUP-04020: found record longer than buffer size supported, 1048576, in d:tmp603sub.txt
KUP-04053: record number 1

-------------------------------------------------------------------------------------------

难道是换行符的原因，但是sqlldr是成功的
果然是换行符的问题
mysql>
select UUID, CYC_CODE, b03_05, b03_06, b03_07, b03_08, b03_09, b03_10, b03_11, b03_12, Cate_Item_Code, product_name, product_unit
from jb603_jb603_sub3 into outfile ''''d:/tmp/603sub.txt''''LINES TERMINATED BY ''''\r\n'''';

SQL> select count(*)from SYS_SQLLDR_X_EXT_JB603_JB603_S;

COUNT(*)
----------
79537

RECORDS DELIMITED BY 0x''''0A''''
SQL> CREATE TABLE "EXT_S"
2 (
3 UUID VARCHAR2(32),
4 CYC_CODE CHAR(2),
5 B03_05 NUMBER(11,2),
6 B03_06 NUMBER(11,2),
7 B03_07 NUMBER(11,2),
8 B03_08 NUMBER(11,2),
9 B03_09 NUMBER(9),
10 B03_10 NUMBER(11,2),
11 B03_11 NUMBER(11,2),
12 B03_12 NUMBER(11,2),
13 CATE_ITEM_CODE VARCHAR2(7),
14 PRODUCT_NAME VARCHAR2(60),
15 PRODUCT_UNIT VARCHAR2(20)
16 )
17 ORGANIZATION external
18 (
19 TYPE oracle_loader
20 DEFAULT DIRECTORY EXT_DATA_DIR
21 ACCESS PARAMETERS
22 (
23 RECORDS DELIMITED BY 0x''''0A'''' CHARACTERSET ZHS16GBK
24 BADFILE ''''UTL_FILE_DIR'''':''''603sub.bad''''
25 LOGFILE ''''t.log_xt''''
26 READSIZE 1048576
27 FIELDS TERMINATED BY 0x''''09'''' LDRTRIM
28 )
29 location
30 (
31 ''''603sub.tx1''''
32 )
33 )
34 /