Re: Alert log File (External tables)

From: Ron <support_at_dbainfopower.com>
Date: Fri, 13 Feb 2004 02:03:28 -0800
Message-ID: <l8CdnQf6oeXrArHdRVn-hQ@comcast.com>

Hello Niall,

  This is a sample. Feel free to alter is.

Regards,

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

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:402c9a55$0$10333$ed9e5944_at_reading.news.pipex.net...
> "Ron" <support_at_dbainfopower.com> wrote in message
> news:qYSdnVX9i89EHbHdRVn-hg_at_comcast.com...
> >
> > Here you go:
> >
> > 1. create directory BDUMP as '...';
> >
> > 2. 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;

>

> How long is a line in an alert.log? Why do you allow 1000 rejects?

>

> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK

>
> Received on Fri Feb 13 2004 - 04:03:28 CST