oracle 10g 的外部表传输机制和oracle 9i对比

 

A． oracle 9i 的应用方法：

   --生成表的格式文件

spool trans_flat.txt

     select grade||','||losal||','||hisal from salgrade;

spool off;

--把trans_flat.txt 放到dump_dir 目录对象的路径下:

--创建外部表

create table salgrade_ext

(

 grade,losal,hisal

)    

oraganization extentrnal

(

 type oracle_loader

 default directory admin

 access parameters

 (

  records delimited by newline

  badfile 'trans_ext.bad'

  logfile 'trans_ext.log'

  discardfile 'trans_ext.dis'

  fields terminated by "," optionally enclosed by '"'

  (

  grade,losal,hisa

  )

 )

 location('trans_flat.txt')

)

reject limit unlimited;

 

B． oracle 10g 的操作方法

---建立目录

create directory dump_dir as 'E:/oracle/product/10.2.0/admin/orcl/bdump';

create table trans_dump

organization external

(

 type oracle_datapump

 default directory dump_dir

 location('trans_dump.dmp')

)

 parallel 2

 as select * from salgrade;