以前没有用过external table ,今天参照例子建了一个,发现不好用, 请大家帮我看看是什么问题. 谢谢拉
08:41:01 oracle[SQLPLUS]@spftprd1[nygespappd3]>select * from dba_directories where directory_name ='TESTDIR';
OWNER
DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
------------------------------------------------------------------------------------------------------------------------
SYS
TESTDIR
/home/oracle/homer
08:08:29 oracle[SQLPLUS]@spftprd1[nygespappd3]> create table externalhhh
(emp_id number(4),
ename varchar2(12),
job varchar2(12) ,
08:08:35 208:08:35 308:08:35 408:08:35 5 mgr_id number(4) ,
hiredate date,
08:08:35 608:08:35 7 salary number(8),
comm number(8),
08:08:35 808:08:35 9dept_id number(2)) organization external
08:08:3510( type ORACLE_LOADER
08:08:3511default directory testdir
08:08:3512 access parameters ( records delimited by newline
08:08:3513 fields terminated by ',')
08:08:3514 location('hhh.dat'))
reject limit 200;
08:08:3515
Table created.
08:37:12 oracle[SQLPLUS]@spftprd1[nygespappd3]> select * from dba_external_tables where table_name ='EXTERNALHHH';
OWNER
TABLE_NAME
TYP TYPE_NAME
DEF
------------------------------ ------------------------------ --- ------------------------------ ---
DEFAULT_DIRECTORY_NAME REJECT_LIMIT
ACCESS_
------------------------------ ---------------------------------------- -------
ACCESS_PARAMETERS
PROPERTY
-------------------------------------------------------------------------------- ----------
ORACLE
EXTERNALHHH
SYS ORACLE_LOADER
SYS
TESTDIR
200
CLOB
records delimited by newline
ALL
fields terminated by ','
08:08:36 oracle[SQLPLUS]@spftprd1[nygespappd3]> select * from externalhhh;
no rows selected
08:08:42 oracle[SQLPLUS]@spftprd1[nygespappd3]> !more hhh.dat
7369,SMITH,CLERK,7902,17-DEC-80,100,0,20
7499,ALLEN,SALESMAN,7698,20-FEB-81,250,0,30
7521,WARD,SALESMAN,7698,22-FEB-81,450,0,30
7566,JONES,MANAGER,7839,02-APR-81,1150,0,20
|