|
,
B03_10 NUMBER(11,2),
B03_11 NUMBER(11,2),
B03_12 NUMBER(11,2),
CATE_ITEM_CODE VARCHAR2(7),
PRODUCT_NAME VARCHAR2(60),
PRODUCT_UNIT VARCHAR2(20)
)
ORGANIZATION external
(
TYPE oracle_loader
DEFAULT DIRECTORY UTL_FILE_DIR
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE CHARACTERSET ZHS16GBK
BADFILE ''''UTL_FILE_DIR'''':''''603sub.bad''''
LOGFILE ''''t.log_xt''''
READSIZE 1048576
FIELDS TERMINATED BY 0x''''09'''' LDRTRIM
REJECT ROWS WITH ALL NULL FIELDS
(
UUID CHAR(255)
TERMINATED BY 0x''''09'''',
CYC_CODE CHAR(255)
TERMINATED BY 0x''''09'''',
B03_05 CHAR(255)
TERMINATED BY 0x''''09'''',
B03_06 CHAR(255)
TERMINATED BY 0x''''09'''',
B03_07 CHAR(255)
TERMINATED BY 0x''''09'''',
B03_08 CHAR(255)
TERMINATED BY 0x''''09'''',
B03_09 CHAR(255)
TERMINATED BY 0x''''09'''',
B03_10 CHAR(255)
TERMINATED BY 0x''''09'''',
B03_11 CHAR(255)
TERMINATED BY 0x''''09'''',
B03_12 CHAR(255)
TERMINATED BY 0x''''09'''',
CATE_ITEM_CODE CHAR(255)
TERMINATED BY 0x''''09'''',
PRODUCT_NAME CHAR(255)
TERMINATED BY 0x''''09'''',
PRODUCT_UNIT CHAR(255)
TERMINATED BY 0x''''09''''
)
)
location
(
''''603sub.txt''''
)
)REJECT LIMIT UNLIMITED
用于加载内部表的 INSERT 语句:
------------------------------------------------------------------------
INSERT /*+ append */ INTO JB603_JB603_SUB3
(
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
)
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 "SYS_SQLLDR_X_EXT_JB603_JB603_S"
用于清除由以前的语句创建的对象的语句:
------------------------------------------------------------------------
DROP TABLE "SYS_SQLLDR_X_EXT_JB603_JB603_S"
从星期日 3月 26 13:11:41 2006开始运行
在星期日 3月 26 13:11:41 2006处运行结束
经过时间为: 00: 00: 00.14
CPU 时间为: 00: 00: 00.04
我摘出建外部表的语句执行
SQL> CREATE TABLE "SYS_SQLLDR_X_EXT_JB603_JB603_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 UTL_FILE_DIR
21 ACCESS PARAMETERS
22 (
23 RECORDS DELIMITED BY NEWLINE 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.txt''''
32 )
33 )
34 /
表已创建。
当603sub.txt记录很少的时候，没问题
SQL> select uuid from SYS_SQLLDR_X_EXT_JB603_JB603_S;
UUID
--------------------------------
00001B3726AD4276AD661393F92F9108
当603sub.txt记录多的时候
SQL> select count(*)from SYS_SQLLDR_X_EXT_JB603_JB603_S;
select count(*)from SYS_SQLLDR_X_EXT_JB603_JB603_S
*
ERROR 位于第 1 行:
ORA-29913: 执行 ODCIEXTTABLEFETCH 调出时出错
ORA-29400: 数据插件错误KUP-04020: found record longer than buffer size
supported, 1048576, in d:tmp603sub.txt
ORA-06512: 在"SYS.ORACLE_LOADER", line 14
ORA-06512: 在line 1
t.log_xt
LOG file opened at 03/26/06 12:52:33
Field Definitions for table SYS_SQLLDR_X_EXT_JB603_JB603_S
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Rows with all null fields are accepted
Fields in Data Source:
UUID CHAR (255)
Terminated by "09"
Trim whitespace same as SQL Loader
CYC_CODE CHAR (255)
Terminated by "09"
Trim whitespace same as SQL Loader
B03_05 CHAR (255)
Terminated by "09"
Trim whitespace same as SQL Loader
B03_06 CHAR (255)
Terminated by "09"
Trim whitespace same as SQL Loader
B03_07 CHAR (255)
Terminated by "09"
Trim whitespace same as SQL Loader
B03_08 CHAR (255)
Terminated by "09"
Trim whitespace same as SQL Loader
B03_09 CHAR (255)
Terminated by "09"
Trim whitespace same as SQL Loader
B03_10 CHAR (255)
Terminated by "09"
Trim whitespace same as SQL Loader
B03_11 CHAR (255)
Terminated by "09"
Trim whitespace same as 上一页 [1] [2] [3] 下一页
[MySql]PHP存取 Mysql 数据乱码终极解决方案 [MySql]解决Table xxx is marked as crashed and should …
[MySql][MySQL]快速解决"is marked as crashed and shoul… [MySql]MySQL DELETE语法用法详解
[MySql]mysql中时间日期格式化 [MySql]修改mysql导入文件大小限制
[其他]MySql常用命令大全 [Web开发]把ACCESS的数据导入到Mysql中的方法详解
[MySql]解决mysql 1040错误Too many connections的方法 [系统软件]EXP-00008: ORACLE error 904 encountered的解决方…
|
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
