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