And load 'em to CLOBs as well and use InterMedia Text to index them ;)
Tanel.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, July 11, 2003 12:59 AM
> > 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
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).
