This content has been marked as final. Show 3 replies
Hi Moorthy,1 person found this helpful
Manual migration from DB2 to Oracle is tough ask.
Please refer the link below to load data into Oracle from DB2 using SQL Loader,
What sort of scripts are you talking about to convert ? Scripts to load data into Oralce or 'create table xxx ...' type scripts ?
And why do you not want to use SQL*Developer as it will do all of that for you ?
Perhaps the following from the SQL Developer documentation is helpful for you:1 person found this helpful
Command-Line Interface for Migration
As an alternative to using the SQL Developer graphical interface for migration operations, you can use the migration batch file (Windows) or shell script (Linux) on the operating system command line. These files are located in the sqldeveloper\sqldeveloper\bin folder or sqldeveloper/sqldeveloper/bin directory under the location where you installed SQL Developer.
migration.bat or migration.sh accepts these commands: capture, convert, datamove, delcaptured, delconn, delconverted, driver, generate, guide, help, idmap, info, init, lscaptured, lsconn, lsconverted, mkconn, qm, runsql, and scan. For information about the syntax and options, start by running migration without any parameters at the system command prompt. For example:
You can use the -help option for information about one or more actions. For the most detailed information, including some examples, use the -help=guide option. For example:
C:\Program Files\sqldeveloper\sqldeveloper\bin>migration -help=guide