SEO

#1 (**permalink**) 02-23-2008, 06:58 AM

Hi,

Thanks all of you for the useful info.
I would like to say that for reading alert log file, we are using
external tables, which is the feature of 9i.
But for 8i, what should we do in order to read the same alert log
file.Because external table feature is not available in Version 8i
Any suggestions will aslo be appreciated.

Thanks

M. King

#2 (**permalink**) 02-23-2008, 06:58 AM

"MATHEW KING" <bzbzzb@hotmail.com> a écrit dans le message de
news:528c8daf.0402152351.5fddb6eb@posting.google.c om...
> Hi,
>
> Thanks all of you for the useful info.
> I would like to say that for reading alert log file, we are using
> external tables, which is the feature of 9i.
> But for 8i, what should we do in order to read the same alert log
> file.Because external table feature is not available in Version 8i
> Any suggestions will aslo be appreciated.
>
> Thanks
>
> M. King

There is no full SQL solution.
You can use sql*loader the same way to load a table with alert.log

A more complex solution is to use an external procedure that
launches the sqlloader. I don't try it, it's just an idea.This is still not a
full SQL solution.

Regards
Michel Cadot

#3 (**permalink**) 02-23-2008, 06:58 AM

> But for 8i, what should we do in order to read the same alert log
> file.Because external table feature is not available in Version 8i
> Any suggestions will aslo be appreciated.
How about setting utl_file_dir in init.ora and using package utl_file?
Stephan

#4 (**permalink**) 02-23-2008, 06:58 AM

bzbzzb@hotmail.com (MATHEW KING) wrote in message news:<528c8daf.0402152351.5fddb6eb@posting.google. com>...
....
> But for 8i, what should we do in order to read the same alert log
> file.Because external table feature is not available in Version 8i
> Any suggestions will aslo be appreciated.

How about UTL_FILE?

Regards,
Igor

> Thanks
>
> M. King

#5 (**permalink**) 02-23-2008, 06:58 AM

bzbzzb@hotmail.com (MATHEW KING) wrote in message news:<528c8daf.0402152351.5fddb6eb@posting.google. com>...
> Hi,
>
> Thanks all of you for the useful info.
> I would like to say that for reading alert log file, we are using
> external tables, which is the feature of 9i.
> But for 8i, what should we do in order to read the same alert log
> file.Because external table feature is not available in Version 8i
> Any suggestions will aslo be appreciated.
>
> Thanks
>
> M. King

Use sql*loader
Sybrand Bakker
Senior Oracle DBA

#6 (**permalink**) 02-23-2008, 06:58 AM

Hello Mathew,

Please, review below link. It seems like a good approach to you problem:

http://www.oracle-base.com/articles/...namicViews.php

Regards,

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

"MATHEW KING" <bzbzzb@hotmail.com> wrote in message
news:528c8daf.0402152351.5fddb6eb@posting.google.c om...
> Hi,
>
> Thanks all of you for the useful info.
> I would like to say that for reading alert log file, we are using
> external tables, which is the feature of 9i.
> But for 8i, what should we do in order to read the same alert log
> file.Because external table feature is not available in Version 8i
> Any suggestions will aslo be appreciated.
>
> Thanks
>
> M. King

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Alert Log file(version 8i)