Re: [External] : DB2 to Oracle Migration

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