Re: SQL LOADER

Jayesh,

To answer this properly it would be useful to know the rules that would fully describe the nature of your source data. Is each field delimited in some way? Could the length of each field be added to the file?

Loader can cope with variable length fields but it depends on exactly how the data is formatted.

Other options are:

1. Use unix tools to re-structure the data so that it is ia format that loader can easily use (as your previous reply indicted)
2. Use PL/SQL (if you are using 7.3 or higher)
3. Use a language you are happy with together with Pro*XXX (e.g. Pro*C).
4. As 1 but use a mixture of Unix and PC tools.

The exact answer depends on your particular skill set and/or how much time you have to acquire additional skills. I tend to agree with you previous replier's view - especially if this requirement is on-going and your solution is going to be re-used.

However, if you are significantly more comfortable with PC technology than Unix and it is a one (or few) off process, it may be easier to ftp the file to a PC (or PC-NFS mount the unix filesystem on a PC) and use something like a spreadsheet or database to re-format the data.

Is that enough options <g>. Without knowing more about the data, all that can be said are the options.

Len

On Fri, 26 Jun 1998 09:17:40 -0500, Jayesh Thakker <jthakker_at_nortel.com> wrote:

>I am trying to load data from a huge log file into a table, the log file
>is not formated and the field sizes are also not fixed, is there any way
>that i can do this using sqlloader or any other tool to populate the
>table.
>Thanks,
>- Jayesh
>
Received on Sat Jun 27 1998 - 05:09:57 CDT