I need to only migrate data (tables + data) from a IBM DB2 database TO Oracle database.
Oracle database version: 126.96.36.199 (operating system Linux)
IBM DB2 database version: 10.1 (operating system z/OS
) database size 300 GB
Unfortunately it seems that I can not use the Oracle SQL Developer Migration tool, because it is not compatible with DB2 running on IBM z/OS
Oracle say that the latest version of SQL*Developer can be used to migrate from DB2 but only when running on Unix, Linux and Windows platforms, but not currently support migrating DB2 running on IBM z/OS.
It seems that the only possible ways to perform the migration, from DB2 on z/OS to Oracle, are:
Oracle Transparent Gateway
Oracle SQL Loader
I need to know if someone can tell me step by step how to do at least one of them and/or if there are other ways to migrate.
Thanks in advance!