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;