Re: ALert Log File(External Table)

Hello Mathew,

  You are not getting full lines because of commas, so in sample, just change access parameters as below:

    access parameters (

        records delimited by newline
        FIELDS TERMINATED by 'DUMMY_XXX'

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.0402150253.5109e457_at_posting.google.com...
> 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
Received on Sun Feb 15 2004 - 12:31:23 CST