Re: [External] : DB2 to Oracle Migration

Hi Frank,

It’s LUW DB2.

Thanks,
Mani

On Mon, Oct 2, 2023 at 5:50 AM Frank Gordon <frankagordon_at_gmail.com> wrote:

> Hello,
>
> You did not mention whether it is Mainframe or LUW DB2.
> If mainframe watch for character sets, EBCDIC vs. UTF.
>
> Regards,
> Frank
>
> On Mon, Oct 2, 2023 at 7:15 AM Jeff Smith <dmarc-noreply_at_freelists.org>
> wrote:
>
>>
>> Unload to flat files then load back in as external tables or sqlldr, SQL
>> Developer will help with that as well.
>> ------------------------------
>> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
>> behalf of manikandan <pvmanikandan_at_gmail.com>
>> *Sent:* Monday, October 2, 2023 12:53 AM
>> *To:* Oracle Mailinglist <oracle-l_at_freelists.org>
>> *Subject:* [External] : DB2 to Oracle Migration
>>
>> Hi,
>>
>> Customer has a requirement to migrate their OnPrem DB2 Database to OnPrem
>> Oracle (19c).
>> DB2 database details :- Relational database with 5600 tables across 10
>> schema ( 600 tables are system tables). Size is 25TB.
>> I believe we can extract the schema/table metadata using say SQL
>> Developer and create schema and empty tables in Oracle.
>> It seems Initial load using Golden Gate is not a viable solution in this
>> case.
>> I am looking for a solution to do an Initial load of data to Oracle.
>> Please suggest.
>>
>> Thanks,
>> Mani
>>
>>
>
> --
> +353-86-0695383
>

--
http://www.freelists.org/webpage/oracle-l