Re: ALert Log File(External Table)

Hello Daniel,

  Did you ever tried or review second example?

  It is clearly not working because of "FIELDS TERMINATED by ' '" - records are skipped and damaged all over.

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:1076867564.264812_at_yasure...
> MATHEW KING wrote:
>
> > Dear Ron and everyone,
> >
> > Thanks for giving the useful information about the external table.
> > But when I query the external table it don't display the full text .
> >
> > For Example:
> >
> > I got the following text from the actual alert log file:
> >
> > control_files = D:\Oracle\oradata\GERMAN\CONTROL01.CTL,
> > D:\Oracle\oradata\GERMAN\CONTROL02.CTL,
> > D:\Oracle\oradata\GERMAN\CONTROL03.CTL
> >
> > But when I query the external table it display the following text:
> >
> > control_files = D:\Oracle\oradata\GERMAN\CONTROL01.CTL
> >
> > How should we display the full text of the above control_files
> > parameter in the external table.
> >
> > Currently I am using Varchar2(4000) datatype for the text column, but
> > the nature of the alert file is extendable, that's why I wanted to use
> > the clob datatype ,but external tables do not support lob datatypes.
> >
> > I also like to say the by default the external table log file is
> > generated on the same path where the actual alert log files is
> > situated.
> > Could we mention the path for external table log files ?
> >
> > THANKS
> >
> > M.KING
>
> The example posted by Ron doesn't work as has been pointed out. Go
> with Michel's example.
>
> --
> 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 Sun Feb 15 2004 - 12:37:49 CST