Migrating AIX C-ISAM data to AIX Oracle DB

[Brett Greiner (Kinetix)]

Hi Peter,

Not too slow at all. 

We think this is the best way to go as well. The Oracle DBA says that
once the data is in Oracle, we can easily move the DB from AIX to any
other platform.

Cheers,
Brett.  

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Peter Bateman
Sent: Wednesday, 23 February 2005 7:15 a.m.
To: powerh-l@lists.sowder.com
Subject: RE: Migrating AIX C-ISAM data to AIX Oracle DB

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(r) 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(r) Premium right now and get
the first two months FREE*.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.