oracle报表警告,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-%';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20976446/viewspace-674323/，如需转载，请注明出处，否则将追究法律责任。