Re: Alert log File (External tables)

Hello Daniel,

  Appreciate you critics.

  You are more then welcome to provide user with the 100% working solution.

  IMHO: having provided sample user can customize it the way he needs it,

Regards,

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

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1076688960.210119_at_yasure...
> Ron wrote:
>
> > 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;
> > Regards,
> >
> > Ron
>
> Alert log lines can be very substantially longer than 80 characters.
> Have you atually used this and if so how could it have worked?
>
> Here are a few lines from my alert log
>
> control_files = C:\OGRID\GRID\CONTROL01.CTL,
> C:\OGRID\GRID\CONTROL02.CTL, C:\OGRID\GRID\CONTROL03.CTL
>
> starting up 1 dispatcher(s) for network address
> '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
>
> db_recovery_file_dest_size of 2147483648 bytes is 0.00% used, and has
> 2147483648 remaining bytes available.
>
> Note that these are allsingle lines.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Fri Feb 13 2004 - 17:51:02 CST