RE: SQL Loader Problem

Hi Suren

I like Perl. Why don't you try it? It's free and easy for understanding. The language has power capabilities for string processing. I think it's a good practice to clean and even sort data by Perl programm before using SQL*Loader

Kind regards,
Ed

>
> Dear all,
> I am facing lot of problems in loading the data from flat
> files(generated from progress database) to Oracle 8i database.
> One of the columns in the data contains a text(maximum 4000
> characters) which contains some formatted(carriage return
> keyssingle quotes ,double quotes etc..) data
> One of my friends helped me a lot in reaching out a near
> solution for this.
> I am facing difficulty when there is a huge data as I will
> have to do lot of formatting in the dat file.
> At present I am managing with the help of Sql Server(MS)'s
> DTS tool.But it is rejecting lot of records saying buffer
> size is small.I am not finding options to increase the
> buffer size.May be it is OS/Sql Sqrver related.
> I would like to know if any of you had problems in loading
> such data and how you overcome.Pl suggest me if there are
> any links or third party tools available.
> Your help is highly appreciated.
>
> Suren
> Oracle DBA,Entegram
>
>
> _________________________________________________
> Get Your Free Email At, http://www.rediffmail.com
>
> Partcipate in crazy Re.1 auctions at http://www.rediff.com/auctions
>
>
>
> --
> Author: surendra tirumala
> INET: surendra_tirumala_at_rediffmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access /
> Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Sep 01 2000 - 01:53:17 CDT