Re: Using external table to load files with fixed pattern

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 2 Mar 2006 19:31:08 +0100
Message-ID: <440739ee$0$11651$626a54ce@news.free.fr>

"suri" <suriawan_at_gmx.de> a écrit dans le message de news: 1141319156.308316.77050_at_t39g2000cwt.googlegroups.com...
| Hi,
|
| I have a log file with following pattern:
|
| [<log ID>] <log message>
| < several lines of detail messages
| .......
| >
| Time: <date>
| Process: <process ID>
| -----------------------
| [<log ID>] <log message>
| < several lines of detail messages
| .......
| >
| Time: <date>
| Process: <process ID>
| -----------------------
|
| Is it possible using external table feature to load that file to table
| and put the values of each attribute <...> to different column?
|
| Thanks for your help,
| Suri
|

Yes, it is possible.

Regards
Michel Cadot Received on Thu Mar 02 2006 - 12:31:08 CST