External Tables - Help Please
From: BN <bnsarma_at_gmail.com>
Date: Mon, 21 Sep 2009 11:58:57 -0400
Message-ID: <61292a9d0909210858r14977f9bo653e61ea6d553112_at_mail.gmail.com>
Greetings
Date: Mon, 21 Sep 2009 11:58:57 -0400
Message-ID: <61292a9d0909210858r14977f9bo653e61ea6d553112_at_mail.gmail.com>
Greetings
I am using Oracle external tables to read alert log to display the content on a webpage
Oracle Version :oracle 9.2.0.4 and oracle10grel2
Looking for a sql to read Today's alert log contents only,
Looked at uinsg AWK to create just todays file only, unless I run this
every 2 mins or so, I wont see the latest alertlog info, dont want to go
this route unless
there is no other option
Here is the SQL right now I am using to read last 100 lines, even this the Timestamp comes after the messages becase of DESC, not in the right order
select rownum,text as "alert_${DB}.log" from (select alert_log.text, rank() over (order by rownum desc) r from alert_log) where r <= 100
Appreciate your help
-- Regards & Thanks BN -- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 21 2009 - 10:58:57 CDT