Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: loading data from tandem to oracle with sqlloader.

Re: loading data from tandem to oracle with sqlloader.

From: Michael S. Abbey <masint_at_istar.ca>
Date: Tue, 30 Jun 1998 23:03:38 GMT
Message-ID: <35996e85.355736882@news.istar.ca>


On Tue, 30 Jun 1998 19:29:16 GMT, maadhavan_at_my-dejanews.com wrote:

>I have to load data from tandem environment to oracle database.The way i think
>this can be solved is FTP the files in tandem to unix box. Then use sqlloader
>to read the flat file into oracle database.How to deal with variable length
>record and records with spaces in flat file. If anybody can suggest me a
>solution how to go about it will be nice of them.
>thanks in advance.

Believe it or not, the Server Utilities documentation on SQL*Loader does a very ncie job on variable length fields.

Michael

+------------------------------------
+  Michael S. Abbey    Ottawa Canada
+  Co-author of Oracle8: A Beginner's Guide
+ and 5 other works in the Oracle Press Series
+------------------------------------
Received on Tue Jun 30 1998 - 18:03:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US