Re: Alert log File (External tables)

From: Ron <support_at_dbainfopower.com>
Date: Thu, 12 Feb 2004 23:52:52 -0800
Message-ID: <qYSdnVX9i89EHbHdRVn-hg@comcast.com>

Here you go:

create directory BDUMP as '...';
create table alert_log ( text varchar2(80) ) organization external ( type oracle_loader default directory BDUMP access parameters ( records delimited by newline ) location('<alert.log>') ) reject limit 1000; Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"MATHEW KING" <bzbzzb_at_hotmail.com> wrote in message news:528c8daf.0402122337.7c05f264_at_posting.google.com...
> Hi Every one,
>
> I want to copy all the contents of An Oracle ALERT Log file in an
> Oracle table dynamically.
> Every time when I run the routine it append the text from alert log
> file into an Oracle table.
> Could someone give me suggestion how should it possible.
> Should I create and use external tables or procedure to do that.
>
> Any ideas will be appreciated.
>
> Regards
>
> M.King
Received on Fri Feb 13 2004 - 01:52:52 CST