Migrating AIX C-ISAM data to AIX Oracle DB

[Peter Bateman]

Brett:

I guess

    Access  <CISAM file>
    Output <Oracle table> add

  is too slow?

Tim:
Do you have a utility that converts a QSHOW  'show record'  listing into
a SQLLDR.ctl file?

Regards,
Peter Bateman

>Brett,
>
>Your best bet is to define a SQLLDR .ctl file for the C-ISAM file in it's
>native form.  I have moved allot of data to Oracle and it is by far the
>fastest way.
>
>Tim Cummings
>Cincinnati, OH
>
>-----Original Message-----
>From: Brett Greiner (Kinetix) [mailto:Brett@Kinetix.co.nz]
>Sent: Thursday, February 17, 2005 8:31 PM
>To: powerh-l@lists.sowder.com
>Subject: Migrating AIX C-ISAM data to AIX Oracle DB
>
>
>
>
>Hi All,
>
>We are investigating on how much effort is required to migrate AIX C-ISAM
>data files to anAIX Oracle Database.
>
>We did export 1000 records to a portable subfile, but it required adding a
>Carrigae-Return character at the end of the record and it also places a +
>sign in front of numerics?
>
>Are there tools that are available for use?
>Has anyone done this before, if so how have they done this?
>
>
>Thanks,
>Brett.
>
>
>
>
>
>

_________________________________________________________________
Take advantage of powerful junk e-mail filters built on patented Microsoft® 
SmartScreen Technology. 
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.