> 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).
