1、我先创建目录create or replace directory dir_bdump as '/usr2/wrnop'
2、创建了组织结构引用刚才的目录。create table temp_dir_oid ( oid varchar2(32) )
organization external (
type oracle_loader
default directory dir_bdump
access parameters (
fields terminated by '|'
)
location('month.txt')
)
reject limit unlimited;
3、之后我查询外部表。select * from temp_dir_oid
ORA-29913: 执行 ODCIEXTTABLEOPEN 调出时出错
ORA-29400: 数据插件错误error opening file /usr2/wrnop/TEMP_DIR_OID_24858.log
2、创建了组织结构引用刚才的目录。create table temp_dir_oid ( oid varchar2(32) )
organization external (
type oracle_loader
default directory dir_bdump
access parameters (
fields terminated by '|'
)
location('month.txt')
)
reject limit unlimited;
3、之后我查询外部表。select * from temp_dir_oid
ORA-29913: 执行 ODCIEXTTABLEOPEN 调出时出错
ORA-29400: 数据插件错误error opening file /usr2/wrnop/TEMP_DIR_OID_24858.log
贴上来看看
实际的数据之间没有发现 ‘|’呀,