Toad World® Forums

Alert log into table?


#1

Yes why not.

CREATE OR REPLACE DIRECTORY bdump AS ‘[your path to alert log file]’;

CREATE TABLE alert_log(TEXT VARCHAR2(400))
ORGANIZATION EXTERNAL (
TYPE oracle_loader
DEFAULT DIRECTORY bdump
ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE
NOBADFILE NODISCARDFILE NOLOGFILE
FIELDS TERMINATED BY ‘0x0A’
MISSING FIELD VALUES ARE NULL)
LOCATION (’[your alert log file name]’))
REJECT LIMIT unlimited;

SELECT * FROM system.alert_log;