Re: Alert log File (External tables)

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)