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>


I am using Oracle external tables to read alert log to display the content on a webpage

Oracle Version :oracle 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

Received on Mon Sep 21 2009 - 10:58:57 CDT

Original text of this message