Thanx Mladen. i have got some scripts now. i have to try one by one and find out which suits my need.
thanx u all. Jp. 10-07-2003 09:09:24, Mladen Gogala <[EMAIL PROTECTED]> wrote: >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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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).