DB2 to Oracle Migration

From: manikandan <pvmanikandan_at_gmail.com>
Date: Sun, 1 Oct 2023 23:53:12 -0500
Message-ID: <CAB6JwgjX_Zn2TuNvFnY=uf=X=-hrm_yB_9p2fyV9gMNvKmQMnw_at_mail.gmail.com>

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.

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

Received on Mon Oct 02 2023 - 06:53:12 CEST

This message: [ Message body ]
Next message: Jeremiah Wilton: "Re: DB2 to Oracle Migration"
Next in thread: Jeremiah Wilton: "Re: DB2 to Oracle Migration"
Reply: Jeremiah Wilton: "Re: DB2 to Oracle Migration"
Maybe reply: Bobby Curtis (DBASOLVED): "Re: DB2 to Oracle Migration"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message