Re: Migration Problem EBCDIC to ASCII

From: Ron van Zijl $Prive$ <zijlr_at_yahoo.com>
Date: Fri, 22 Mar 2002 00:36:42 +0100
Message-ID: <a7dr00$49u$1@news1.xs4all.nl>

If you are doing migration in a unload load type of way you could create an fixed width EBCDIC file on RS/6000, ftp it over and load it using SQL*Loader.

SQL*Loader is able to do character set conversion. You just state in the loader file what character set it is in and it will convert it automatically during the load to the character set the Oracle DB is set to run under. Next to that SQL*Loader is incredably fast for loading data.

Used it a lot, also with packed decimal fields and it works like a charm.

Ron

"Jens Junker" <J.Junker_at_kdt.de> wrote in message news:a725q5$l58$1_at_news.kdt.de...
> Hi,
>
> I am currently evaluating some szenarios to migrate a huge volume of data
> from an IBM host to a RS/6000 with an Oracle 9i database.
>
> Beside others,one of the problems is EBCDIC / ASCII conversion.
>
> Does Oracle 9i support a codeset which allows to store EBCDIC data on a
> RS/6000 with an Oracle 9i database?
>
> Many thanks
> Jens
>
>
Received on Thu Mar 21 2002 - 17:36:42 CST