Re: [External] : DB2 to Oracle Migration
Date: Mon, 2 Oct 2023 06:14:30 +0000
Message-ID: <SJ0PR10MB46866ED1641B4CD3DE25DB9AA3C5A_at_SJ0PR10MB4686.namprd10.prod.outlook.com>
Unload to flat files then load back in as external tables or sqlldr, SQL Developer will help with that as well.
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,
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
Mani
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 02 2023 - 08:14:30 CEST