Oracle之外部表警告日志
首先需要创建一个Directory
SQL> create or replace directory bdump as '/u01/app/oracle/admin/orcl/bdump';
查询确认
SQL> col DIRECTORY_PATH for a30
SQL> col owner for a10
SQL> select * from dba_directories;
创建一个外部表:
SQL> create table alert_orcl ( text varchar2(4000) )
organization external (
type oracle_loader
default directory BDUMP
access parameters (
records delimited by newline
nobadfile
nodiscardfile
nologfile
)
location('alert_orcl.log')
)
reject limit unlimited
/
通过外部表进行查询警告日志的内容:
SQL> select * from alert_log where rownum < 51;
查看数据库中曾经出现过的ORA-错误
SQL> select * from alert_log where text like 'ORA-%';
SQL> create or replace directory bdump as '/u01/app/oracle/admin/orcl/bdump';
查询确认
SQL> col DIRECTORY_PATH for a30
SQL> col owner for a10
SQL> select * from dba_directories;
创建一个外部表:
SQL> create table alert_orcl ( text varchar2(4000) )
organization external (
type oracle_loader
default directory BDUMP
access parameters (
records delimited by newline
nobadfile
nodiscardfile
nologfile
)
location('alert_orcl.log')
)
reject limit unlimited
/
通过外部表进行查询警告日志的内容:
SQL> select * from alert_log where rownum < 51;
查看数据库中曾经出现过的ORA-错误
SQL> select * from alert_log where text like 'ORA-%';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/20976446/viewspace-674323/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Oracle之外部表监听日志
请登录后发表评论
登录
全部评论
