SQL> CREATE EXTERNAL TABLE EMP(C1 INT,C2 VARCHAR(10))
FROM DATAFILE DEFAULT DIRECTORY OPT LOCATION ('emp.txt')
PARMS(FIELDS DELIMITED BY ',');2 3
操作已执行
已用时间: 10.131(毫秒). 执行号:2207.
SQL> select * from DMTEST.EMP;
select * from DMTEST.EMP;
第1 行附近出现错误[-2106]:无效的表或视图名[EMP].
已用时间: 0.570(毫秒). 执行号:0.
SQL> drop table EMP;
操作已执行
已用时间: 33.575(毫秒). 执行号:2208.
SQL> CREATE EXTERNAL TABLE DMTEST.EMP(ID INT,NAME VARCHAR(10),BIRTHDAY date)
FROM DATAFILE DEFAULT DIRECTORY OPT LOCATION ('emp.txt')
PARMS(FIELDS DELIMITED BY ',');2 3
操作已执行
已用时间: 14.560(毫秒). 执行号:2209.
SQL> select * from dmtest.emp;
select * from dmtest.emp;
[-7082]:外部表数据错误.
已用时间: 9.320(毫秒). 执行号:0.
SQL> drop table DMTEST.EMP;
操作已执行
已用时间: 45.625(毫秒). 执行号:2211.
SQL> CREATE EXTERNAL TABLE DMTEST.EMP(ID INT,NAME VARCHAR(10),BIRTHDAY date)
FROM DATAFILE '/opt/emp.txt') PARMS(FIELDS DELIMITED BY ',');2
CREATE EXTERNAL TABLE DMTEST.EMP(ID INT,NAME VARCHAR(10),BIRTHDAY date)
FROM DATAFILE '/opt/emp.txt') PARMS(FIELDS DELIMITED BY ',');
第 2 行, 第 44 列[)]附近出现错误[-2609]:外部表不支持的操作.
已用时间: 1.584(毫秒). 执行号:0.
SQL> CREATE EXTERNAL TABLE DMTEST.EMP(ID INT,NAME VARCHAR(10),BIRTHDAY date) FROM DATAFILE '/opt/emp.txt') PARMS(FIELDS DELIMITED BY ',');
CREATE EXTERNAL TABLE DMTEST.EMP(ID INT,NAME VARCHAR(10),BIRTHDAY date) FROM DATAFILE '/opt/emp.txt') PARMS(FIELDS DELIMITED BY ',');
第 1 行, 第 168 列[)]附近出现错误[-2609]:外部表不支持的操作.
已用时间: 0.491(毫秒). 执行号:0.
SQL> create EXTERNAL TABLE t_extemp
(ID INT,NAME VARCHAR(10),BIRTHDAY date)
from DATAFILE DEFAULT DIRECTORY OPT LOCATION ('emp.txt')
parms (fields DELIMITED by ',', records 0x0a,skip 1, character_code 'UTF-8');2 3 4
操作已执行
已用时间: 14.060(毫秒). 执行号:2212.
SQL>

正确语句
create EXTERNAL TABLE DMTEST.EMP
(ID INT,NAME VARCHAR(10),BIRTHDAY date)
from DATAFILE DEFAULT DIRECTORY OPT LOCATION ('emp.txt')
parms (fields DELIMITED by ',', records 0x0a,skip 1, character_code 'UTF-8');