Oracle数据库开发-外部表应用

1 对监听日志的外部表信息

create directory listener_log as '$ORACLE_HOME/network/log/';
grant read,write on directory listener.log to monitor;

create table listener_log(text varchar2(2000))
organization external(
type oracle_loader
default directory listener_log
access parameters(
  records delimited by newline
  nobadfile
  nologfile
  nodiscardfile
  )
  location ('listener.log')
  )
  reject limit unlimited;

---告警日志外部表

---告警日志外部表
create directory ALERT_log as 'D:\app\Administrator\virtual\diag\rdbms\orcl\orcl\trace';
grant read,write on directory ALERT_log to TB;

create table ALERT_LOG(text varchar2(2000))
organization external(
type oracle_loader
default directory ALERT_log
access parameters(
  records delimited by newline
  nobadfile
  nologfile
  nodiscardfile
  )
  location ('alert_orcl.log')
  )
  reject limit unlimited;