create or replace directory data_dir as '/app/oracle/admin/gsweb/bdump/'
/
-- copy dm_hz.csv to $oracle_base/admin/gsweb/bdump/
create table dm_hz
(
hz varchar2(10) ,
py varchar2(10) ,
sd varchar2(10) ,
wb varchar2(10) ,
yxbz varchar2(10)
)
organization external
(type oracle_loader
default directory data_dir
access parameters
(
records delimited by newline
fields terminated by ','
missing field values are null
( hz ,
py,
sd,
wb ,
yxbz
)
)
location ('dm_hz.csv')
)
/
|
