学步园

申明 
看了这个东西后 我就查了相关的资料  
在完成目录以及目标表的创建成功后，做了下查询的时候还是有错误 （角色是dba的角色)

'alert_orcl.log'----  alert_oracle_sid.log

（
SQL> select * from oracle_log
  2 /
select * from oracle_log
*
第 1 行出现错误:
ORA-29913: 执行 ODCIEXTTABLEOPEN 调出时出错
ORA-29400: 数据插件错误KUP-00554: error encountered while parsing access
parameters
KUP-01005: syntax error: found "identifier": expecting one of: "badfile,
byteordermark, characterset, column, data, delimited, discardfile, exit,
fields, fixed, load, logfile, language, nodiscardfile, nobadfile, nologfile,
date_cache, processing, readsize, string, skip, territory, variable"
KUP-01008: the bad identifier was: delimied
KUP-01007: at line 1 column 9
ORA-06512: 在 "SYS.ORACLE_LOADER", line 19

）
后面查了错误也没找到相应的答案 只能寻求罗哥 也在他的帮助下解决了外部表查看报警日志的错误
下面公布下过程

SQL code

--在此多谢罗哥的帮助 呵呵

SQL> col owner format a10
SQL> col directory_path format a50
SQL> set linesize 150
SQL> select * from dba_directories
  2  /

OWNER      DIRECTORY_NAME                 DIRECTORY_PATH
---------- ------------------------------ --------------------------------------------------
SYS        ADMIN_DIR                      C:/ADE/aime_10.2_nt_push/oracle/md/admin
SYS        DATA_PUMP_DIR                  F:/oracle/product/10.2.0/admin/orcl/dpdump/
SYS        D_READ                         d:/test
SYS        WORK_DIR                       C:/ADE/aime_10.2_nt_push/oracle/work
SYS        MY_DIR                         d:/emp
SYS        D_IR                           f:/oracle
SYS        LOG_DUMP                       F:/oracle/product/10.2.0/admin/orcl/bdump

已选择7行。

SQL> drop directory LOG_DUMP
  2  /

目录已删除。

SQL> create or replace directory bdump as 'F:/oracle/product/10.2.0/admin/orcl/bdump'
  2  /

目录已创建。

SQL> grant read,write on directory bdump to scott
  2  /

授权成功。

SQL> conn scott/sys
已连接。

SQL> edi
已写入 file afiedt.buf

  1  create table oracle_log( text varchar2(1000))
  2  organization external (
  3  type oracle_loader
  4  default directory BDUMP
  5  access parameters (
  6   records delimited by newline
  7  nobadfile
  8  nodiscardfile
  9  nologfile
 10  )
 11  location('alert_orcl.log')
 12  )
 13* reject limit unlimited
SQL> /

表已创建。

SQL> select * from oracle_log where rownum<9
  2  /

TEXT
------------------------------------------------------------------------------------------------
Dump file f:/oracle/product/10.2.0/admin/orcl/bdump/alert_orcl.log
Fri Jan 29 13:35:32 2010
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU                 : 2 - type 586
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:1368M/2038M

已选择8行。




SQL> select * from oracle_log where instr(TEXT,'ora_')>0
  2  /

TEXT
------------------------------------------------------------------------------------------------
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_528.trc:
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_528.trc:
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_528.trc:
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_4140.trc:
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_4140.trc:
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_4140.trc:
Details in trace file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_22444.trc
Details in trace file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_24080.trc
Details in trace file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_14920.trc
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_7424.trc:
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_7424.trc:

TEXT
------------------------------------------------------------------------------------------------
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_8796.trc:
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_8796.trc:
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_8796.trc:
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_8796.trc:
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_8796.trc:
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_8796.trc:
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_8796.trc:
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_8796.trc:
Details in trace file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_6248.trc
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_17340.trc:
Errors in file f:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_17340.trc: