Oracle外部表小例

1)建立操作系统目录e:\test，准备数据文件dept.txt并置于e:\test之下
"10","ACCOUNTING","NEW
YORK"
"20","RESEARCH","DALLAS"
"30","SALES","CHICAGO"
"40","OPERATIONS","BOSTON"
2)创建数据库目录对象e_test
CREATE directory e_test AS
'e:\test';
 
3)定义外部表
CREATE TABLE new_dept(deptno
NUMBER(2)
                    
,dname
VARCHAR2(14)
                    
,loc VARCHAR2(13))
organization EXTERNAL(TYPE oracle_loader
                     
DEFAULT directory
e_test
                     
access PARAMETERS(records delimited BY
newline
                                       
badfile
'dept.bad'
                                       
discardfile
'dept.dsc'
                                       
logfile
'dept.log'
                    &