> Here is a good one: > create or replace directory bdump as > '/oracle/admin/o9i/bdump' / grant read on directory bdump to > public / create table alert_log_ext ( line varchar2(2000) ) > organization external ( type oracle_loader default directory > bdump access parameters > ( > records delimited by newline > nobadfile nologfile nodiscardfile > fields (line char(132) > ) > ) > location('alert_o9i.log') ) > reject limit unlimited > / > > You can now write a PL/SQL or Java procedure to parse > alert_log_ext table if your heart so desires. There is only > one problem: this doesn't work if you don't have 9iR2. Or if the database isn't up.....
I do like the idea though, could centralize all alert.logs and indeed listener.logs etc in one db. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).