新手提问:ORACLE 10G 维护-》实用程序-》从文件中加载数据,这里面的控制文件我自己编写如下(test.ctl):
load data
infile 'test.txt'
into table purchase_orders
(po_id number by ',',
po_date date by ',',
po_desc varchar2 by ',',
po_item varchar2 by whitespace ) 数据文件如下(test.txt)
1,25-MAY-2005,office equipment,optical mouse
2,18-JUN-2005,computer system,dell laptop
3,26-JUN-2005,travel expense,car rental这样加载之后,提示如下错误,该如何修改控制文件?
SQL*Loader-350: Syntax error at line 4.
Expecting valid column specification, "," or ")", found "number".
(po_id number by ',',
^ SQL*Loader: Release 10.1.0.2.0 - Production on ææä¸ 8æ 27 10:05:11 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL*Loader-350: Syntax error at line 4.
Expecting valid column specification, "," or ")", found "number".
(po_id number by ',',
^
load data
infile 'test.txt'
into table purchase_orders
(po_id number by ',',
po_date date by ',',
po_desc varchar2 by ',',
po_item varchar2 by whitespace ) 数据文件如下(test.txt)
1,25-MAY-2005,office equipment,optical mouse
2,18-JUN-2005,computer system,dell laptop
3,26-JUN-2005,travel expense,car rental这样加载之后,提示如下错误,该如何修改控制文件?
SQL*Loader-350: Syntax error at line 4.
Expecting valid column specification, "," or ")", found "number".
(po_id number by ',',
^ SQL*Loader: Release 10.1.0.2.0 - Production on ææä¸ 8æ 27 10:05:11 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL*Loader-350: Syntax error at line 4.
Expecting valid column specification, "," or ")", found "number".
(po_id number by ',',
^
解决方案 »
- plsql无法连接linux orcle
- Oracle存储过程
- ORACLE远程服务器的问题!紧急求救!(在线等待!)
- 用FORM BUILDER 去打开一个FMB 文件,结果出了FRM-10043:打不开文件
- 古老的问题,连接Oracle时出错:System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
- oracle9i 启动时默认使用哪个参数文件呢?
- SYSTEM我知道用在SQLPLUS上,可是SYS我怎么连接不上去,她用在哪里啊,我想建立个新的管理员帐号怎么建立啊?用OEM说什么包不能访问,但
- 有谁知道oracle各个版本的发布时间和每个版本同上一个版本新增加的功能区别吗吗?
- 怎么备份库和恢复库?
- 将excel的日期导入到sqldeveloper中格式是什么
- 关于数据库灭备问题。。多谢!
- oracle插入数据太慢,重启系统,好了
infile 'test.txt'
into table purchase_orders
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(po_id ,
po_date ,
po_desc ,
po_item)