Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Assorted questions about uploading a flat ascii text file ported from an IBM mainframe
Daniel Morgan
george lewycky wrote:
> Assorted questions about uploading a flat ascii text file ported from
> an IBM mainframe
>
> 1. What is the best/easiest method or utility for uploading the data
> to an Oracle database (running on Win NT). I’m hearing and
> finding out about more than I expected.
>
> I’d appreciate hearing about past experiences, the pro’s
> and con’s, web sites, etc
>
> I’ve been told a mixture of the following: UTL_File, SQL*PLUS,
> Discoverer, Export/Import, Migration Workbench (OTN), SQLLOADER,
> Oracle Bulk Loader
>
> 2. Parsing the fields (eg, comma or “,”). Which works best
>
> create table customer
> ( authcust char(05) not null,
> name char(25) not null,
> address1 char(25),
> address2 char(25),
> address3 char(25),
> address4 char(25),
> citycountry char(18),
> state char(02),
> zip char(05),
> phone char(10),
> contact char(25) )
> ;
>
> Below is a sample of the flat file that I parsed with double colons
> and a comma since spaces and other characters exist.
>
> "10066","ABC BUS MANUFACTURING ","1506 30TH STREET
> ","NORTHWES
> "10068","ABC RAIL PRODUCTS CORP. ","11TH & WASHINGTON STREETS","
> "10070","ABCO REFRIGERATION SUPPLY","49-70 31ST STREET ","
> "10090","ABEE PRINTING CORP. ","305-1 KNICKERBOCKER AVE. ","
>
> Thanks in Advance
>
> George R Lewycky
> NY City Transit Authority
> Brooklyn NYC USA
>
> gelewyc_at_nyct.com
Received on Fri Feb 08 2002 - 13:43:33 CST